topic Re: Mixed Dates to YYYY-MM-DD in SAS Programming

Mixed Dates to YYYY-MM-DD

SASPhile — Mon, 23 Dec 2019 23:13:44 GMT

I'm looking for an efficient way to convert a column that has mixed dates to YYYY-MM-DD.

Your help is aprreciated

Raw_Date

01 NOV 2019

01-NOV-19

Corrected_Date

2019-11-01

Re: Mixed Dates to YYYY-MM-DD

novinosrin — Mon, 23 Dec 2019 23:24:28 GMT

Hi, For your sample Raw data , date11 is a natural informat.

/*reading as raw data*/
data have;
input date date11.;
format date yymmdd10.;
cards;
01 NOV 2019
01-NOV-19
;
/*If it's a sas dataset*/
data have;
input date $11.;
cards;
01 NOV 2019
01-NOV-19
;

data want;
set have;
new_date=input(date,date11.);
format new_date yymmdd10.;
run;

Re: Mixed Dates to YYYY-MM-DD

r_behata — Tue, 24 Dec 2019 02:55:34 GMT

data have;
input Raw_Date ANYDTDTE.;
Raw_Date_New=put(Raw_Date,yymmddd10.);

put Raw_Date_New =;
cards;
01 NOV 2019
01-NOV-19
;
run;

Log :

 Raw_Date_New=2020-11-01
 Raw_Date_New=2019-11-01