10-10-2013 11:49 AM
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)"
getnames = yes;
10-12-2013 10:05 AM
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.