topic Re: How to convert below dates to as required format? in SAS Programming

How to convert below dates to as required format?

rajeshalwayswel — Thu, 05 Dec 2019 05:34:57 GMT

data have;
input date $15.;
cards;
UN-UNK-2019
UN-NOV-2010
UN-JAN-2019
10-JAN-2018
;
run;

Want:

2019-UNK-UN
2010-11-UN
2019-01-UN
2018-01-10

Re: How to convert below dates to as required format?

Jagadishkatam — Thu, 05 Dec 2019 06:00:16 GMT

please try

data have;
input date $15.;
if scan(date,2,'-') ne 'UNK' then do;
month=month(input(cats('01',scan(date,2,'-'),'2019'),date9.));
date2=tranwrd(date,scan(date,2,'-'),put(month,z2.));
end;
else date2=date;
newdate=prxchange('s/(.*)\-(.*)\-(.*)/$3-$2-$1/',-1,strip(date2));
cards;
UN-UNK-2019
UN-NOV-2010
UN-JAN-2019
10-JAN-2018
;
run;

Re: How to convert below dates to as required format?

Kurt_Bremser — Thu, 05 Dec 2019 06:37:18 GMT

You really do not "convert" here, you just reshuffle and reformat the values. Your output does not constitute dates, as dates always refer to a specific day within a specific month within a specific year. Basically, you don't change anything to the better.

Since you have incomplete values in your input, I suggest two possible approaches:

set up a rule how to replace "UN" and "UNK" with specific days and months, so you can have complete SAS dates
store separate year, month and day values, and set the "UN" and "UNK" to missing; that way you can always decide later how to treat those missing values within the context of your analysis, and non-missing values can be assembled into a date with the mdy() function.