topic Re: How SAS read two digit year in Oracle in SAS Programming

How SAS read two digit year in Oracle

nbonda — Tue, 01 Dec 2015 21:31:36 GMT

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.

Re: How SAS read two digit year in Oracle

ballardw — Tue, 01 Dec 2015 21:55:08 GMT

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?

Re: How SAS read two digit year in Oracle

nbonda — Sat, 05 Dec 2015 02:29:39 GMT

In oracle table it two digit year is displaying, but it has 4 digit year. SAS extracting properly only. Thank you for your response.

Re: How SAS read two digit year in Oracle

Patrick — Sat, 05 Dec 2015 02:40:56 GMT

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.