Excel import macro

[fapg]

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;

[Tom]

Your little program will import the same sheet to three different datasets. You are changing the name of the target SAS dataset in the OUT= parameter, but you are NOT changing the name of the input Excel sheet in the SHEET= parameter.

Try:

Sheet="Sheet&i$";