filename Out dde 'Excel|C:\Users\you\Desktop\SAS\[AAA.xls]Datasource!Z7S3:Z26S7';


' Use Solutions --> Accesories --> DDE triplet;

data Test2;
set Test;
file Out;
put A B C D;
run;

filename In dde 'Excel|C:\Users\you\Desktop\SAS\[AAA.xls]Datasource!Z7S3:Z26S7';

data Input;
infile In;
input A $ B C D;
run;