Macro call not executed

[JasonNC]

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]

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]

Hi Art,

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