BookmarkSubscribeRSS Feed
ballardw
Super User

As  I have mentioned a time or two, show the code you have run. All of it at this point in time.

I have seen many different problems with Excel dates and the one you show almost certainly involves your code changing a value as read from Excel.

 

One thing to try is to make sure that entire columns of Excel have the same cell formatting, especially dates.

Save the file as CSV.

Then import the CSV file, use the option guessingrows=max or the number of lines in the file.

You are much more likely to get usable dates that way.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 15 replies
  • 6476 views
  • 3 likes
  • 4 in conversation