EXCEL date/time conversion error

Reply
Occasional Contributor
Posts: 18

EXCEL date/time conversion error

Hi,

 

When importing my excel sheet, the date/time conversion is not correct.  Only method that worked was converting it into CSV file but then I would have to format the rest of the columns.

 

I also tried "41000" method of -21916 but that didn't work.  Below is a screenshot of the excel and the values it looks like after importing.

 

Someone please help import the correct dates, Thanks.

 

asdf.jpg

 

Esteemed Advisor
Posts: 5,541

Re: EXCEL date/time conversion error

Posted in reply to HitmonTran

"but that didn't work" is not a useful description of what went wrong. SAS converts some date variables when it recognizes an Excel date format, but it misses some. You can either change the format in Excel so that it is recognized by SAS as a date format, or do your own convversion in SAS after importing.  

PG
Occasional Contributor
Posts: 18

Re: EXCEL date/time conversion error

I did a format change to "date" but values still remained the same with a decimal. Tried using sas date format and it gives me a missing value.
Esteemed Advisor
Posts: 5,541

Re: EXCEL date/time conversion error

Posted in reply to HitmonTran

Please show the SAS code you are using.

PG
Super User
Posts: 23,776

Re: EXCEL date/time conversion error

Are those supposed to be the same values?
The standard correction methods don't work and I don't understand why....

Ask a Question
Discussion stats
  • 4 replies
  • 155 views
  • 0 likes
  • 3 in conversation