DATA Step, Macro, Functions and more

DATETIMES FROM EXCEL INTO SAS

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,041
Accepted Solution

DATETIMES FROM EXCEL INTO SAS

 

 

 

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

 

 

 

Accepted Solutions
Solution
‎02-12-2016 12:17 PM
Frequent Contributor
Posts: 96

Re: DATETIMES FROM EXCEL INTO SAS

Posted in reply to robertrao
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

View solution in original post


All Replies
Frequent Contributor
Posts: 96

Re: DATETIMES FROM EXCEL INTO SAS

Posted in reply to robertrao
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.
Super User
Posts: 19,870

Re: DATETIMES FROM EXCEL INTO SAS

Posted in reply to robertrao
What does proc contents show on the imported variable type and format
Solution
‎02-12-2016 12:17 PM
Frequent Contributor
Posts: 96

Re: DATETIMES FROM EXCEL INTO SAS

Posted in reply to robertrao
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
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 207 views
  • 1 like
  • 3 in conversation