macro variable in proc export excel file name

[peppapig]

Code have:

%MACRO A (VAR01, VAR01STR);

PROC EXPORT

DATA= &VAR01

OUTFILE='C:\DATA\VAR01STR.XLSX'

DBMS = XLSX REPLACE;

RUN;

%MEND;

%A(ID01,%STR(ID01.));

Want output file with name ID01.XLSX.

But right now output file name is VAR01STR.XLSX

Thanks!

[Reeza]

You need to reference a macro variable using &, so &var01STR.

And if quoting, you need double quotes for the macro variable to resolve.

Also, you need to add a . to denote where the variable name ends, so SAS know's the which macrovariable to resolve.

%MACRO A (VAR01, VAR01STR);

PROC EXPORT

DATA= &VAR01

OUTFILE='C:\DATA\&VAR01STR..XLSX'

DBMS = XLSX REPLACE;

RUN;

%MEND;

%A(ID01,%STR(ID01.));

[ballardw]

AND the string has to use " instead of '

"C:\data\&Var01Str..xlsx"

[kuridisanjeev]

Yes,

Macro variable wonn't resolve in Single Quotes " ' ".

Sanjeev.K