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.
You need double quotes for macro variables to resolve.
You need double quotes for macro variables to resolve.
Great, it works! Thank you so much!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.