topic Re: DATETIMES FROM EXCEL INTO SAS in SAS Programming

DATETIMES FROM EXCEL INTO SAS

robertrao — Sat, 06 Feb 2016 18:20:36 GMT

Hello Team,

I hav the dates in Excel spreadsheet as shown: 2/24/14 22:03 and i am importing the data into a SAS dataset. The date gets imported as a numeric SAS date MMDDYY10. (02/24/2014) ...When i try to convert this sas date into a datetime format it gives me wrong dates like shown(something from 1906's): 01JAN60:05:29:39.

Can anyone suggest me how to import correct datetimes from the spreadsheet.

Regards

Re: DATETIMES FROM EXCEL INTO SAS

Kalind_Patel — Sat, 06 Feb 2016 20:43:21 GMT

Hi,
You are going in wrong way,
You first converted datetime to date format and then again you converted sas date values to sas datetime format, that's why you are getting wrong values;

Instead of that directly convert it to datetime.
Thanks.

Re: DATETIMES FROM EXCEL INTO SAS

Reeza — Sun, 07 Feb 2016 01:30:08 GMT

What does proc contents show on the imported variable type and format

Re: DATETIMES FROM EXCEL INTO SAS

Kalind_Patel — Sun, 07 Feb 2016 05:31:26 GMT

Refer this paper,
It gives clear idea about convert excel datetime to sas datetime values.
Link :http://www2.sas.com/proceedings/sugi31/020-31.pdf