BookmarkSubscribeRSS Feed
HitmonTran
Pyrite | Level 9

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

 

4 REPLIES 4
PGStats
Opal | Level 21

"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
HitmonTran
Pyrite | Level 9
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.
PGStats
Opal | Level 21

Please show the SAS code you are using.

PG
Reeza
Super User

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1483 views
  • 0 likes
  • 3 in conversation