Converting Main frame dates

[kajal_30]

I have a mainframe date as 1200617 and I want to use the same date in my base sas to do a data filtration.

Can anyone please help how can I convert this date to use in a base sas?

[Nicole_Fox]

I like the solution below that I found on the web. Here's the link that will credit the source and explain the solution:
https://www.experts-exchange.com/questions/28126605/Coverting-data-from-CYYMMDD-to-MM-DD-YYYY-in-SAS...

data date;
date_str = "1050527";
IF date_str = : "2" then date_str2 = "20"||SUBSTR(date_str,2);
ELSE date_str2 = "19"||SUBSTR(date_str,2);

date = input(date_str2, yymmdd8.);
/* if you wish to store the converted value as a SAS date displayed as mm/dd/yyyy */
format date mmddyys10.;
/* if you wish to store the converted value as a character displayed as mm/dd/yyyy */
new_date_str = put(date, mmddyys10.);
run;

[ChrisNZ · Accepted solution]

Why are you asking again? The answer was given (please choose an answer in the other thread) :

data HAVE;
  *Format cYYMMDD - c= century number:  0 for 1800, 1 for 1900, 2 for 2000 ;       
  DATE =  1990401 ;
  DATEZ = input(put(18000000+DATE,z8.),yymmdd8.);
  format DATEZ date9.;
run;

It looks like for you, if C = 0 then it's 1900 and if C = 1 it's 2000, like here.

So you need to add 19000000.

Is this what you mean?

[kajal_30]

May I know the criteria for adding 18000000 or 19000000 ?

[ChrisNZ]

> May I know the criteria for adding 18000000 or 19000000 ?

Do you want a date starting with 120  to be 1920 or 2020?

[kajal_30]

I want it to be 2020 

[kajal_30]

In case mainframe data has both old and new records and we have no idea if they are from year 2020 or 1900 is there a generic way to convert them into SAS dates?