Hi Experts:
I’m trying to learn macro. I have an Excel2010 file with multiple worksheets and their names all end with “_rpt”. For example the first tab’s name is Sales_rpt and the second is Budget_rpt. I want to write a macro that makes it easier for me to create SAS dataset from specified sheets.
Here is my failed attempt to create a SAS dataset called Sales by using a data step reading in the Sales_rpt worksheet.
What did I do wrong?
Thank you!
Libname rpt ‘….xlsx';
%macro getdata(DSN);
Data work.&DSN;
set rpt."&DSN_rpt$"n;
run;
%mend;
%getdata(Sales)
Hi,
try
Libname rpt ‘….xlsx';
%macro getdata(DSN);
Data work.&DSN;
set rpt."&DSN._rpt$"n;
run;
%mend;
%getdata(Sales)
/* you need a . after macro variable &dsn. */
Linlin
Magic! Thank you so much!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.