topic Re: How to change specific year in the date variable in SAS Programming

How to change specific year in the date variable

psychopedia — Thu, 09 Jun 2016 23:40:39 GMT

Hi ! I have this date variable in my dataset. Some of the year in the date is wrong and I want to change it. For instance, some of the date value has year 2074, but I want to change it to 2014. Is there anyway I can do that? Thank you!

Re: How to change specific year in the date variable

ChrisBrooks — Fri, 10 Jun 2016 00:20:14 GMT

The easiest way to change the year portion of a date is with by using the intnx function intnx function reference

You can use negative values for the increment as well as positive ones.

Re: How to change specific year in the date variable

Reeza — Fri, 10 Jun 2016 00:47:32 GMT

Sure, what does your variable look like, is it a SAS date?

if year(date)=2074 then date=mdy(month(date), day(date), 2014);

Re: How to change specific year in the date variable

Astounding — Fri, 10 Jun 2016 01:17:59 GMT

Should all the dates be 2014? If not, how do you know what to change and what to change it to? One example isn't enough to illustrate the changes that need to be made.

Re: How to change specific year in the date variable

psychopedia — Fri, 10 Jun 2016 01:39:42 GMT

some of the date is 2074, which should be 2014. The date has the date9. format

Re: How to change specific year in the date variable

psychopedia — Fri, 10 Jun 2016 01:40:47 GMT

It has a date9. format. I tried your method first, but the error shows

ERROR: Undeclared array referenced: year.
ERROR: Variable year has not been declared as an array

for some reason.

Re: How to change specific year in the date variable

ballardw — Fri, 10 Jun 2016 01:49:36 GMT

Assuming your date variables are actually SAS dates this is one way.

data want;
  set have;
  if year(date) = 2074 then date=mdy(month(date), day(date),2014);
run;

The MDY function builds a SAS date value from a month, day of month and year. The functions Month and Day give you those bits.

Re: How to change specific year in the date variable

Reeza — Fri, 10 Jun 2016 01:56:01 GMT

Post your code and log as well as a proc contents from your dataset.

Re: How to change specific year in the date variable

Astounding — Fri, 10 Jun 2016 01:58:29 GMT

Just in case you find other cases ... maybe 2073 should become 2013 ... this might be a little more generalizable:

data want;

set have;

if year(date) = 2074 then date = intnx('year', date, -60, 'same');

run;

If 2073 should be 2013, you could change just the IF condition:

if year(date) in (2013, 2014) then ...

Re: How to change specific year in the date variable

PGStats — Fri, 10 Jun 2016 02:45:05 GMT

I think the only way to get that error is to use brackets [] or braces {} instead of parentheses () to call function Year.

if year[date] = 2074 then ...

Re: How to change specific year in the date variable

PGStats — Fri, 10 Jun 2016 03:02:13 GMT

The 60 year difference probably occurs as a result of an import from Excel or MS-Access. The reference date in MS-Office is Jan 01 1900 (which has value = 1) and is Jan 01 1960 in SAS (which has value = 0). The difference between the two systems is actually 60 years and one day (a difference in value of 21916). You should thus use

correctDate = ExcelDate - 21916;

Re: How to change specific year in the date variable

Kurt_Bremser — Fri, 10 Jun 2016 05:44:10 GMT

@psychopedia wrote:

It has a date9. format. I tried your method first, but the error shows

ERROR: Undeclared array referenced: year.
ERROR: Variable year has not been declared as an array

for some reason.

Then show your code and the portion of the log including the code.