topic Re: How to change the year to current year without changing the month and day? in SAS Programming

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

mrafael03 — Tue, 21 Jul 2020 22:31:40 GMT

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

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

PaigeMiller — Tue, 21 Jul 2020 22:37:39 GMT

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

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

mrafael03 — Tue, 21 Jul 2020 23:28:57 GMT

it's returning 0 value

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

PaigeMiller — Tue, 21 Jul 2020 23:58:37 GMT

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.

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

mrafael03 — Wed, 22 Jul 2020 00:29:53 GMT

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?

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

Kurt_Bremser — Wed, 22 Jul 2020 05:05:29 GMT

To display the values as dates, apply a date format

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