Hi I'm pretty new with SAS, I have 36 Excel files, each of them have the header placed in different row, I don't want to open each file in order to specify the range. Is there any shortcut I can use? PROC IMPORT DATAFILE= "C:\Users\File1.xlsx" OUT= phi.file1 DBMS=excel REPLACE; getnames=yes; RANGE="A6:W10000"; run; PROC IMPORT DATAFILE= "C:\Users\file2.xlsx" OUT= phi.file2 DBMS=excel REPLACE; getnames=yes; RANGE="A9:W10000"; run;
... View more