topic Macro call not executed in SAS Programming

Macro call not executed

JasonNC — Fri, 24 Feb 2017 03:15:46 GMT

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?

art297 — Fri, 24 Feb 2017 03:33:04 GMT

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

JasonNC — Fri, 24 Feb 2017 12:53:15 GMT

Hi Art,

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