topic Re: Converting Main frame dates in SAS Programming

Converting Main frame dates

kajal_30 — Sun, 21 Jun 2020 20:58:43 GMT

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?

Re: Converting Main frame dates

Nicole_Fox — Sun, 21 Jun 2020 21:25:20 GMT

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.html

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;

Re: Converting Main frame dates

ChrisNZ — Sun, 21 Jun 2020 21:29:04 GMT

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?

Re: Converting Main frame dates

kajal_30 — Tue, 23 Jun 2020 03:03:33 GMT

May I know the criteria for adding 18000000 or 19000000 ?

Re: Converting Main frame dates

ChrisNZ — Tue, 23 Jun 2020 03:52:08 GMT

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

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

Re: Converting Main frame dates

kajal_30 — Tue, 23 Jun 2020 12:58:14 GMT

I want it to be 2020

Re: Converting Main frame dates

kajal_30 — Tue, 23 Jun 2020 13:28:27 GMT

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?