BookmarkSubscribeRSS Feed
nbonda
Obsidian | Level 7

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.

3 REPLIES 3
ballardw
Super User

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?

nbonda
Obsidian | Level 7
In oracle table it two digit year is displaying, but it has 4 digit year. SAS extracting properly only. Thank you for your response.
Patrick
Opal | Level 21

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.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1107 views
  • 1 like
  • 3 in conversation