topic Date Conversion from MMM-YY to sortable Date in New SAS User

Date Conversion from MMM-YY to sortable Date

jskarda — Wed, 05 Jun 2019 17:33:57 GMT

We have a database with a date field in MMM-YY format. Is there a method to convert to a sortable date into a new date column with the last day in the month specified. JAN-19 to be 01/31/2019. FEB-19 to be 02/28/2019.

Re: Date Conversion from MMM-YY to sortable Date

Jagadishkatam — Wed, 05 Jun 2019 18:01:14 GMT

Please try intnx

data have;
input date $;
newdate=intnx('month',input(cats('01-',date),anydtdte.),0,'end');
format newdate date9.;
cards;
JAN-19
Feb-19
;

Re: Date Conversion from MMM-YY to sortable Date

ballardw — Wed, 05 Jun 2019 20:01:44 GMT

Or minor difference from @Jagadishkatam

data have;
input date $;
newdate=intnx('month',input(date,monyy.),0,'end');
format newdate date9.;
cards;
JAN-19
Feb-19
;

Re: Date Conversion from MMM-YY to sortable Date

jskarda — Wed, 05 Jun 2019 20:55:51 GMT

Thank you. Could you please return in the form of a statement?
proc sql;
update WORK.FILE
set COLUMNB=intnx('month',input(cats('01-',date),anydtdte.),0,'end');
run;

DATA in its original format is in a column named COLUMNA. It could contain
any month or year, but we would like the last day in any given month

Stored Value in COLUMNA='APR-19'
New value produced in COLUMNB should be April, 30, 2019 in a sortable format.