convert numeric date into DATE in SAS Enterprise Guide

Question

I have a date column which dates are showing as numeric, such as "201101", "201203"... How can I convert these numeric date into format as "Jan2011", "Mar2012" by using SAS enterprise? Thanks!

Have you tried anything yet? – DeadChex Jun 25 '15 at 21:29 — DeadChex, Jun 25 '15 at 21:29
I am new to SAS, tried several ways, but not work – Shirley Jun 27 '15 at 20:39 — Shirley, Jun 27 '15 at 20:39

score 1 · Answer 1 · answered Jun 26 '15 at 11:25

1

You can do it like this:

DATA test;
    input date;
    CARDS;
201101
201203
    ;
RUN;


data test2;
    set test;
    date2 = input(put(date,6.),yymmn6.);
    format date2 monyy7.;
run;

answered Jun 26 '15 at 11:25

Martí Mayo

31
5

I tried yours, but it deletes all other columns, only the date columns left. I am new to SAS, is there anyway to transfer the column without delete others? – Shirley Jun 27 '15 at 20:38

score 0 · Answer 2 · answered Jun 26 '15 at 11:52

Marti Mayo's answer is correct - but just wanted to point out that it only needs the one step:

DATA test;
format date monyy7. ; *<--- Sets the format you want to view     (JAN2011) ;
input date :yymmn6.;  *<--- Sets the informat of what you read in(201101);
CARDS;
201101
201203
;RUN;

convert numeric date into DATE in SAS Enterprise Guide

2 Answers2