Convert char yyyymon to date (DATE9.)

[mbarkauskas]

Hi there,

probably it is a boring subject, but I haven't found proper solutiion for it yet. Maybe you can help me:

I do have column of dates which are of type char, and looks like 2014Jan, 2014Feb, etc.

At the end I would like to have DATE9. format with the last day of the month e.g. 2014Jan -> 31JAN2014.

As a first step I try to convert each char date to yymon7. format by using input function, but it returns cells with '.' value.

WOuld you share your knowledge how to proceed?

Thanks a lot for help.

[Jagadishkatam · Accepted solution]

Please try intnx

data have;
x='2014jan';
x1=intnx('month',input(compress('01'||substr(x,5)||substr(x,1,4)),date9.),1)-1;
put x1=;
format x1 date9.;
run;

[mbarkauskas]

Perfect , many thanks.