Changing Year

[AbuChowdhury]

Hi Experts,

My dataset looks the following.

Start_Date    CUSIP

27/01/2004	80685710
24/02/2004	80685710
26/08/2004	80685710
15/09/2004	80685710
23/11/2004	80685710
28/07/2005	80685710

I want the output like the following that means I want to add a column where one year will be added to the Start_Date to get the End_Date:

Start_Date    CUSIP         End_Date

27/01/2004   80685710     27/01/2005

...

...

28/07/2005  80685710       28/07/2006

[Reeza]

INTNX function

SAS(R) 9.3 Functions and CALL Routines: Reference

[stat_sas · Accepted solution]

data have;

input Start_Date :anydtdte. CUSIP;

format Start_Date End_date ddmmyy10.;

End_date=intnx('year',start_Date,1,'S');

datalines;

27/01/2004 80685710

24/02/2004 80685710

26/08/2004 80685710

15/09/2004 80685710

23/11/2004 80685710

28/07/2005 80685710

;

proc print data=have;

run;