sas DATE creation

[CamRutherford]

Hello,

I have an output column with just the text 'January' or 'February' etc.

I want to create another column adjacent that will be a date in the following format, '01JAN2017'.

My issue is that I always want the date to be the first of the month but for the current year.

Eg. 

January = '01Jan2017'

February = '01Feb2017'

etc etc

Any ideas?

Thanks,

Cam

[Astounding]

One idea:

new_column = '01' || substr(month, 1, 3) || put(today(), year4.);

[CamRutherford]

Hi,

This doesn't work. I just get empty column.

Cheers,

[Astounding]

"This doesn't work" isn't really helpful.  Can you post the log from your attempt that didn't work?

[kaverisonu1]

It does work

data new;
input month $;
cards;
January
February
March
April
May
June
July
August
September
October
November
December
;
run;
data new1;
set new;
new_col='01';
new_col1=upcase(substr(month,1,3));
new_col2=put(today(),year4.);
fin_col=new_col || strip(new_col1) || trim(new_col2);
run;