topic Re: Informat 2-digit year to 4-digit year? in SAS Programming

Informat 2-digit year to 4-digit year?

chouchou — Thu, 04 Sep 2014 02:16:54 GMT

Hi guys,

01/01/11 2001 2001 1911

I'm trying to resolve the raw data(left data set) 02/23/05 to (right data set) 2002 1923 2005

03/15/15 2003 1915 1915

05/09/06 2005 2009 2006

Below is my code:

options yearcutoff=1910;

data range;

infile datalines dlm='/';

input year1: yy4.

year2: yy4. How to informat year to make a 2-digit year to be a 4-digit year? Thank you in advance.

year3: yy4.;

datalines;

01/01/11

02/23/05

03/15/15

05/09/06

;

run;

Re: Informat 2-digit year to 4-digit year?

art297 — Thu, 04 Sep 2014 03:22:15 GMT

options yearcutoff=1910;

data range (drop=i);

infile datalines dlm='/';

format date1-date3 date9.;

array dates(*) date1-date3;

array years(3) year1-year3;

input date1-date3;

do i=1 to 3;

dates(i)=mdy(1,1,dates(i));

years(i)=year(dates(i));

end;

datalines;

01/01/11

02/23/05

03/15/15

05/09/06

;

Re: Informat 2-digit year to 4-digit year?

jakarman — Thu, 04 Sep 2014 05:54:47 GMT

Chouchou you are learning, I know. This question is meant to get you aware of several things.

1/ dates in SAS are not bound by digits it is only using the number of days since 1jan1960.

2/ reading years / dates wit a two digit / four digit the famous millennium bug (no real bug) is having a sliding window (options yearcutoff). With that the fourdigit expansion

3/ with a delimited file you can specify a length with formats, mostly the length is ignored.

known and conversions (inpt) are implied done.
Run the code to verify this behavior.

Re: Informat 2-digit year to 4-digit year?

Loko — Thu, 04 Sep 2014 10:26:56 GMT

Hello,

Another solution:

data range;

infile datalines ;
input ;

array year{3};

do i=1 to 3;
year{i}=put(mdy(1,1,substr(_infile_,i+2*(i-1),2)),year4.);
end;

datalines;
01/01/11
02/23/05
03/15/15
05/09/06
;

drop i;
run;

Re: Informat 2-digit year to 4-digit year?

RW9 — Thu, 04 Sep 2014 10:48:51 GMT

I think its a bit dangerous, for instance your test data:

01/01/11 2001 2001 1911

What makes 01 be 2001, and 11 be 1911? Surely it could as easily be 2011. I would check the souce (raw data) and fix that. E.g. if from database is there a spec which details what that data is, if Excel check back with person sending it and ask them to provide full information etc.

Re: Informat 2-digit year to 4-digit year?

data_null__ — Thu, 04 Sep 2014 11:09:38 GMT

I believe this is an example of how YEARCUTOFF works, in which case 11 becomes 2011 because of the OPTIONS YEARCUTOFF=1910;

Re: Informat 2-digit year to 4-digit year?

chouchou — Sat, 06 Sep 2014 02:02:41 GMT

Hi Loko,

Can you please elaborate _infile_,i+2*(i-1),2 a little bit more?

I would be greatly appreciate it.

Thank you.