topic Re: Leading zero in month funtion in SAS Procedures

Leading zero in month funtion

nicnad — Fri, 23 Aug 2013 17:46:33 GMT

Hi,

I have a column named DT_MESSG_FINNCR that contains date like the following :

01APR2013

I want to add a new column named date_mois_annee that would contain the year and month.

I use the following code :

data mylib.depuis_aout_2008;

set mylib.depuis_aout_2008;

length month $7;

date_mois_annee=catx('-', year(dt_messg_finncr), month(DT_MESSG_FINNCR));

run;

Now my result is 2013-4... what is the proper way to get 2013-04?

Thank you for your help and time.

Haikuo — Fri, 23 Aug 2013 18:04:50 GMT

data mylib.depuis_aout_2008;

set mylib.depuis_aout_2008;

length month $7;

date_mois_annee=catx('-', year(dt_messg_finncr), put(month(DT_MESSG_FINNCR),z2.));

run;

Haikuo

Tom — Fri, 23 Aug 2013 18:33:59 GMT

date_mois_annee = put(dt_messg_finncr,yymmd7.) ;

nicnad — Fri, 23 Aug 2013 19:28:59 GMT

Thank you both for your help with this.

Both solutions work fine.