 |
|
| File Format-Specific Reference for the IMPORT and EXPORT Procedures |
The Conversion of Date and Time Values between SAS Data Sets and Microsoft Access Database
In Microsoft Access database software:
-
Date values are valid back to 30 December 1899 and is saved as integer value: 0.
-
Date values are valid ahead to 31 December 9999, and is saved as the integer: 2,958,465.
-
Considers years 4000 and 8000 as leap years.
-
Time value is the decimal portion of a number that represents time as a proportion of a day.
-
Numbers can have both a date and a time portion, the format is in date/time format.
-
Can display a number in a date, time, or date/time format.
In SAS software:
-
Dates are valid back to A.D.1582.
-
Date values before year 1582 are represented as missing values.
-
Dates are valid forward to A.D. 9,999.
-
Date values are represented by the number of days between January 01, 1960, and that date.
-
Years 4000 and 8000 are not considered leap years.
-
Time values are represented by the number of seconds between midnight and that time of day.
-
Date and time values are represented by the number of seconds between midnight January 01, 1960, and that date and time.
-
Time values can be imported as a date value 30 Dec 1899. Ensure that you assign the correct format.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.