How to change the year to current year without changing the month and day?

[mrafael03]

Date Set

ID           DATE

001         10/01/2014
002         08/29/2019

 003        03/17/2020

Expected Result

ID           DATE

001         10/01/2020
002         08/29/2020

003         03/17/2020

[PaigeMiller · Accepted solution]

date=mdy(month(date), day(date), 2020);

[mrafael03]

it's returning 0 value

[PaigeMiller]

In the original data set, is variable date a true SAS date value? Is it numeric or character?

Show us the full log of this data step, do not chop anything out.

[mrafael03]

So the source has a data type of date
Here's what I did:

proc sql;
create table test2 as select
ID
,mdy(month(date), day(date), 2020) AS next_dt
from test1
group by ID;
quit;

THEN RESULT:
ID next_dt (data type numeric)
001 22189
001 22156

How do I change the data type of next_dt field to date?

[Kurt_Bremser]

To display the values as dates, apply a date format

mdy(month(date), day(date), 2020) as next_dt format=mmddyy10.