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.
"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.
Please show the SAS code you are using.
Are those supposed to be the same values?
The standard correction methods don't work and I don't understand why....
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.