topic Re: Changing Year in SAS Programming

Changing Year

AbuChowdhury — Sun, 19 Apr 2015 16:56:48 GMT

Hi Experts,

My dataset looks the following.

Start_Date CUSIP

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 — Sun, 19 Apr 2015 17:24:16 GMT

INTNX function

stat_sas — Sun, 19 Apr 2015 17:30:13 GMT

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;