topic Re: date to yyyymm as numeric in New SAS User

date to yyyymm as numeric

jffeudo86 — Tue, 17 Sep 2019 16:17:07 GMT

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 — Tue, 17 Sep 2019 16:21:04 GMT

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

novinosrin — Tue, 17 Sep 2019 16:21:44 GMT

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

I will not ask "why" 🙂

jffeudo86 — Tue, 17 Sep 2019 16:24:07 GMT

Thank you! That did the trick!

novinosrin — Tue, 17 Sep 2019 16:25:27 GMT

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