Create a macro variable with spaces

[SASdevAnneMarie]

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 !

[PaigeMiller]

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.

[Kurt_Bremser · Accepted solution]

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;

[SASdevAnneMarie]

Thank you, Kurt !