Hello, I am trying to import data from 3 Excel sheets into separate SAS datasets. I cannot figure out where I am messing up the macro - I suspect I am not defining "sheet" right (am I even definign "sheet"...?). This is also the first macro that I tried to write in SAS so that probably explains it. Thanks a lot! %macro import(sheet = ); %do i=1 %to 3 ; proc import out = work.sheet&i. datafile = "(location)" DBMS=Excel Replace; Sheet="Sheet$"; getnames = yes; run; %end; %mend import;
... View more