DATA Step, Macro, Functions and more

Excel import macro

Reply
N/A
Posts: 1

Excel import macro

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;

Super User
Super User
Posts: 7,076

Re: Excel import macro

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

Ask a Question
Discussion stats
  • 1 reply
  • 253 views
  • 0 likes
  • 2 in conversation