Excel import macro

fapg — Thu, 10 Oct 2013 15:49:37 GMT

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;

Re: Excel import macro

Tom — Sat, 12 Oct 2013 14:05:45 GMT

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$";

topic Re: Excel import macro in SAS Programming

Excel import macro

Re: Excel import macro