Leading zero in month funtion

[nicnad]

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 · Accepted solution]

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]

date_mois_annee = put(dt_messg_finncr,yymmd7.) ;

[nicnad]

Thank you both for your help with this.

Both solutions work fine.