hybrid format in the dataset, How to input into SAS

Fred_Gavin — Mon, 09 Nov 2009 21:58:18 GMT

I have the dataset with a column of DATE. However, my supervisor arranged the file from different sources. So the column of DATE in the excel file are not all in DATE formate. eg.

There are both 25/06/2001, and 20000312 in that column, which the first is DATE format, but the second is recognized as numerical value. It's fairly easy to input just with either of them. But how to input both types of DATE presenting in the same column?

Thank you very much.

Fred

Re: hybrid format in the dataset, How to input into SAS

Patrick — Tue, 10 Nov 2009 05:57:42 GMT

Hi Fred

Use the informate ANYDTDTEw. as it digest different date strings and transforms them into as SAS date, i.e:

data _null_;
infile datalines;
input mydates:ANYDTDTE10.;
format mydates date9.;
put mydates=;
datalines;
25/06/2001
20000312
;

HTH
Patrick

topic Re: hybrid format in the dataset, How to input into SAS in SAS Procedures

hybrid format in the dataset, How to input into SAS

Re: hybrid format in the dataset, How to input into SAS