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.
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
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
date_mois_annee = put(dt_messg_finncr,yymmd7.) ;
Thank you both for your help with this.
Both solutions work fine.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.