Macro Variables and Extra Space

[BCNAV]

This is simple...but I'm stumped. I have:

data ESRA.&month_label._&year_want; set ESRA.CURRENTMONTH; run;

This makes a dataset called MARCH_2019

I would like MARCH 2019  (note the no underscore). I have tried a bunch of different ways but I know the marco references can be a bit strange when spaces are concerned.

Thanks

[Astounding]

Nothing to do with macro language.

Data set names are not allowed to contain a blank.

[Tom · Accepted solution]

Don't do that.  You can put the space in the label.

data ESRA.&month_label._&year_want (label="&month_label. &year_want"); 
  set ESRA.CURRENTMONTH; 
run;

If you really want to then you will need to use a name literal.

options validmemname=extend;
data ESRA."&month_label. &year_want"n (label="&month_label. &year_want"); 
  set ESRA.CURRENTMONTH; 
run;

[Kurt_Bremser]

Don't do that. See Maxim 44.

[BCNAV]

thanks all....I had forgotten about the space....I was asked to see if it could be done.  Cheers!