topic Re: macro variable in proc export excel file name in SAS Programming

macro variable in proc export excel file name

peppapig — Thu, 12 Dec 2013 21:01:15 GMT

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!

Re: macro variable in proc export excel file name

Reeza — Thu, 12 Dec 2013 21:12:17 GMT

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.));

Re: macro variable in proc export excel file name

ballardw — Thu, 12 Dec 2013 22:32:15 GMT

AND the string has to use " instead of '

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

Re: macro variable in proc export excel file name

kuridisanjeev — Fri, 13 Dec 2013 12:18:03 GMT

Yes,

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

Sanjeev.K