I have a macro
%Rpt(flg)
ods tagsets.ExcelXP options(autofit_height="yes" sheet_name="&tab");
proc report data=&flg
......
run;
%Mend;
%Macro Out();
OPTIONS FORMCHAR="|----|+|---+=|-/\<>*" nobyline;
ods tagsets.excelxp file = "\\corp\test.xls" ;
%Rpt(test1);
%Rpt(test);
ods tagsets.Excelcp close;
%Mend;
%Out();
It's not showing an error but not creating the output.
Any error in the way i am calling?
You're not showing enough of your code. Does your macro start with:
%macro Rpt(flg);
If not, the SAS wouldn't know that it was supposed to be creating a macro.
Art, CEO, AnalystFinder.com
Hi Art,
It's weird I closed the session and ran the code again it worked
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.