Hello Experts,
I'm wondering how to create a macro variable with spaces : %let Feuille = Villes et rues
I would like to use this macro varaible in proc export's sheet statement :
.....
dbms=xlsx replace;
sheet="&Feuille .";
.....
Thank you for your help !
Just make sure there's no blank between the macro variable name and the dot:
%let Feuille = Villes et rues;
proc export
data=sashelp.class
file="/folders/myfolders/class.xlsx"
dbms=xlsx
replace
;
sheet="&Feuille.";
run;
I'm not sure what the question is, the code you provided (if you add a semi-colon at the end of the %LET statement) should work perfectly.
Just make sure there's no blank between the macro variable name and the dot:
%let Feuille = Villes et rues;
proc export
data=sashelp.class
file="/folders/myfolders/class.xlsx"
dbms=xlsx
replace
;
sheet="&Feuille.";
run;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.