date to yyyymm as numeric

[jffeudo86]

Hello,

Could someone help me with converting a date to yyyymm (numeric)?  Here's how I would like to use my code:

%let xdate = '01NOV2018'd;
%let yymm = <code here to return 201811 as numeric>;

proc sql;
select *
from xx
where timeframe = &yymm;
quit;

Thanks.

[jffeudo86]

Please don't ask why do I have to use xdate and go straight to 201811.  

[novinosrin · Accepted solution]

Hi @jffeudo86 

%let xdate = '01NOV2018'd;
%let yymm = %sysfunc(putn(%sysevalf(&xdate),yymmn6.));
%put &=yymm;

I will not ask "why" 🙂

[jffeudo86]

Thank you! That did the trick!

[novinosrin]

You're always welcome. Have a nice day! Cheers!