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;