Macro reference could not be recognized?

[ybz12003]

Hello:

I have the follow macro program. I found the ‘&&state.may.xlsx’ could not be translated to ‘MDmay.xlsx’ during procedure. I have tried ‘&state.may.xlsx’ too, it still didn’t work. Please help, thanks.

%let State=MD;

%let folder='\\abc.org\HHE\SAS\report\SASfiles\&&state.may.xlsx';

%macro export;

%mend;

option symbolgen mprint;

%include"\\abc.org\HHE\SAS\report\SASfiles\ExportMacro.sas" / lrecl=32767 source2;

%export

SYMBOLGEN: && resolves to &.

SYMBOLGEN: Macro variable I resolves to 21

SYMBOLGEN: Macro variable X21 resolves to Settings

SYMBOLGEN: Macro variable FOLDER resolves to

'\\abc.org\HHE\SAS\report\SASfiles\&&state.may.xlsx'

MPRINT(EXPORT): PROC EXPORT DATA= Settings

outfile='\\abc.org\HHE\SAS\report\SASfiles\&&state.may.xlsx' dbms=xlsx

replace;

MPRINT(EXPORT): WXLX;

SYMBOLGEN: && resolves to &.

SYMBOLGEN: Macro variable I resolves to 21

SYMBOLGEN: Macro variable X21 resolves to tblSettings

MPRINT(EXPORT): sheet= Settings;

MPRINT(EXPORT): run;

NOTE: The export data set has 384 observations and 2 variables.

NOTE: "\\abc.org\HHE\SAS\report\SASfiles\&&state.may.xlsx" file was

successfully created.

[Reeza · Accepted solution]

You need double quotes for macro variables to resolve.

[ybz12003]

Great, it works!  Thank you so much!