topic Re: How to get month as a string from date in the format 'mm' in SAS Programming

How to get month as a string from date in the format 'mm'

bradja — Thu, 31 Aug 2017 04:34:38 GMT

Hi All,

I'm relatively new to SAS programming having had experience with MSSQL, MySQL mostly.

I am trying to get the month as a string from a date in the format 'mm'.

For example: 01JAN2017 would result in '01'. 01FEB2017 would result in '02' etc.

I need the preceding 0 for months 1-9

I have been looking at PUT function(?) to do this but cannot find a format that is going to do what I need it to do.

Anyone have any solution or ideas to point me in the right direction?

RahulG — Thu, 31 Aug 2017 04:38:56 GMT

Try this

data _null_;

dt='01Jan17'd;
mon_val=put(month(dt),z2.);
put mon_val=;
run;

bradja — Thu, 31 Aug 2017 04:41:35 GMT

You my friend, are a legend.
This appears to do exactly what I need!