DATA Step, Macro, Functions and more

Macro call not executed

Regular Contributor
Posts: 160

Macro call not executed

I have a macro




ods tagsets.ExcelXP options(autofit_height="yes" sheet_name="&tab");


proc report data=&flg







%Macro Out();


OPTIONS FORMCHAR="|----|+|---+=|-/\<>*" nobyline;
ods tagsets.excelxp file = "\\corp\test.xls" ;


ods tagsets.Excelcp close;






It's not showing an error but not creating the output.


Any error in the way i am calling?

Super User
Posts: 8,213

Re: Macro call not executed

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,


Regular Contributor
Posts: 160

Re: Macro call not executed

Hi Art,


It's weird I closed the session and ran the code again it worked

Ask a Question
Discussion stats
  • 2 replies
  • 1 like
  • 2 in conversation