topic Re: Importance of January 1 1960 in SAS Programming

Importance of January 1 1960

SASuserlot — Mon, 08 May 2023 19:47:01 GMT

I am aware of the importance of January 1 1960 in SAS (considers them as Birthday), SAS stores the days counting from this particular date.

I am not 100% sure but when sometimes I used the wrong date format / informat I used to see this date in my datasets. Can you guys please share some information on this and also provide an example where we see January 1, 1960, in the dataset because of giving the wrong format / informat?

Thanks in advance

Re: Importance of January 1 1960

Kurt_Bremser — Mon, 08 May 2023 19:52:46 GMT

Applying a datetime format to a date value will usually end with a displayed date on 1960-01-01, because most dates used lie between 0 and 86400.

Re: Importance of January 1 1960

ballardw — Mon, 08 May 2023 21:27:22 GMT

SAS datetime values are numbers of seconds.

SAS Date values are numbers of days.

When treat a Date value as if it should be a Datetime then the actual value is way smaller than a datetime format, or function, expects.

Data _null_;
   x=today();
   put 'Numeric value of x is ' x best5.;
   put 'X is: ' x date9. ' with date9. format';
   put 'X is: ' x datetime9. ' with datetime9. format';
run;

When you accidentally use a datetime value where a date is expected you may get invalid data range messages or just exceed the display capability of a format.

Data _null_;
   x='06FEB1960:00:00:01'dt;
   put 'Numeric value of x is ' x best8.;
   put 'X is: ' x date9. ' with date9. format';
   put 'X is: ' x datetime19. ' with datetime9. format';
run;

The above shows that by 6 Feb 1960 the number of seconds exceeds the number of years that SAS date formats are expected to deal with. The **** when displayed with a partial date indicates the "year" the formatted encountered was greater than 9999 but less than 20,000. If you see all ********* for a date you have attempted to use a date that is year 20000 or greater. Which happens by 18Mar1960:00:00:01.

Re: Importance of January 1 1960

SASuserlot — Tue, 09 May 2023 13:19:17 GMT

Thank you very much for quick response.

Re: Importance of January 1 1960

SASuserlot — Tue, 09 May 2023 13:20:18 GMT

Thank you for a detailed explanation.