Macro reference could not be recognized?

Accepted Solution Solved
Reply
Super Contributor
Posts: 274
Accepted Solution

Macro reference could not be recognized?

[ Edited ]

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.

 


Accepted Solutions
Solution
2 weeks ago
Grand Advisor
Posts: 17,464

Re: Macro reference could not be recognized?

You need double quotes for macro variables to resolve.

View solution in original post


All Replies
Solution
2 weeks ago
Grand Advisor
Posts: 17,464

Re: Macro reference could not be recognized?

You need double quotes for macro variables to resolve.

Super Contributor
Posts: 274

Re: Macro reference could not be recognized?

Great, it works!  Thank you so much!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 59 views
  • 0 likes
  • 2 in conversation