topic Re: sas DATE creation in SAS Programming

sas DATE creation

CamRutherford — Tue, 04 Apr 2017 10:17:35 GMT

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

Re: sas DATE creation

Astounding — Tue, 04 Apr 2017 10:25:36 GMT

One idea:

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

Re: sas DATE creation

CamRutherford — Tue, 04 Apr 2017 11:21:43 GMT

Hi,

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

Cheers,

Re: sas DATE creation

Astounding — Tue, 04 Apr 2017 11:30:42 GMT

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

Re: sas DATE creation

kaverisonu1 — Tue, 04 Apr 2017 12:54:30 GMT

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;