12-01-2015 04:31 PM
Hi SAS users,
I am using SAS on linux platform.
A date column has been pulled from Oracle, the values wilth two digit year are showing as four year digit in SAS datasets .
for instance the date value in Oracle is 12-Jan-00 12:59:59.99999000 PM, SAS is reading it as 12JAN3000:13:00:00.000000.
How sas understanding two digit year 00 as 3000 instead of 2000. I am getting the right year though which is 3000.
I have checked the yearcutoff option in my system, its 1920 ( I got this info by using proc option option=yearcutoff;run
I am uisng SQL pass through to connect to Oracle server.
Thank you in advance.
12-01-2015 04:55 PM
What is the informat shown for the SAS variable?
And I would also ask how you know which century the 12-Jan-00 12:59:59.99999000 value represents?
12-04-2015 09:40 PM
Don't confuse how numbers get printed/formatted with how they are stored.
In Oracle a date value is stored in a column of type DATE (which contains a datetime value). SAS will always convert this into the correct SAS Datetime value. The 2 or 4 digit year is only how values get printed, not how they are stored internally.