topic Re: Create a macro variable with spaces in SAS Programming

Create a macro variable with spaces

SASdevAnneMarie — Thu, 29 Apr 2021 12:29:18 GMT

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 !

Re: Create a macro variable with spaces

PaigeMiller — Thu, 29 Apr 2021 12:32:20 GMT

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.

Re: Create a macro variable with spaces

Kurt_Bremser — Thu, 29 Apr 2021 12:53:56 GMT

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;

Re: Create a macro variable with spaces

SASdevAnneMarie — Thu, 29 Apr 2021 13:11:15 GMT

Thank you, Kurt !