Help using Base SAS procedures

Leading zero in month funtion

Accepted Solution Solved
Reply
Regular Contributor
Posts: 186
Accepted Solution

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
Respected Advisor
Posts: 3,124

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

View solution in original post


All Replies
Solution
‎08-23-2013 02:04 PM
Respected Advisor
Posts: 3,124

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
Super User
Posts: 6,500

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 158 views
  • 5 likes
  • 3 in conversation