Macro reference could not be recognized?

ybz12003 — Wed, 12 Jul 2017 15:42:36 GMT

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.

Re: Macro reference could not be recognized?

Reeza — Wed, 12 Jul 2017 15:30:09 GMT

You need double quotes for macro variables to resolve.

Re: Macro reference could not be recognized?

ybz12003 — Wed, 12 Jul 2017 15:41:38 GMT

Great, it works! Thank you so much!

topic Macro reference could not be recognized? in SAS Programming

Macro reference could not be recognized?

Re: Macro reference could not be recognized?

Re: Macro reference could not be recognized?