## Leading zero in month funtion

Solved
Regular Contributor
Posts: 186

# Leading zero in month funtion

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.

Accepted Solutions
Solution
‎08-23-2013 02:04 PM
Posts: 3,167

## Re: Leading zero in month funtion

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

All Replies
Solution
‎08-23-2013 02:04 PM
Posts: 3,167

## Re: Leading zero in month funtion

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

Super User
Posts: 8,114

## Re: Leading zero in month funtion

date_mois_annee = put(dt_messg_finncr,yymmd7.) ;

Regular Contributor
Posts: 186

## Re: Leading zero in month funtion

Thank you both for your help with this.

Both solutions work fine.

🔒 This topic is solved and locked.