Assign a library using a numerical macro variable

[catmad]

I would like to assign a library with a macro variable when the pathname includes a numerical folder name.

I want to create a library with the following path;

libname wsale '/sasserver/my_unit/data/Wholesale/201810';

I would like to derive 201810 from the user input which is 

%let USER_MTH_END = '31OCT2018'd; 

How can I create 201810 and then pass it to the libname statement? I've tried many things but I can't get it to work without manually typing 201810 in the libname statement.

Thanks in advance

[Kurt_Bremser · Accepted solution]

data _null_;
call symputx('period',put(&user_mth_end.,yymmn6.));
run;

libname wsale "/sasserver/my_unit/data/Wholesale/&period.";

[catmad]

Many thanks Kurt - that was very quick. I think I hadn't tried the correct combination of double quotes and a "." after the variable name.

[RW9]

Without double quotes macro variables will not get resolved, they just remain as the string '&...'.  The dot following the macro variable isn't technically needed in a lot of scenarios, it it there to tell the macro pre-processor that the macro variable name ends at the point, however in some circumtances it is really required, hence good practice is to always put the point at the end of the macro variable name - it will also highlight it as a macro variable in your code.