topic Re: calculate one year before the date in New SAS User

calculate one year before the date

Smitha9 — Wed, 13 Jan 2021 23:46:24 GMT

Hi,

I have a dataset:

ID DOB

1 09/07/2003

2 10/03/2004

3 08/08/2003

I want dataset One year Before:

ID DOB

1 09/07/2002

2 10/03/2003

3 08/08/2002

thanks in advance.

Re: calculate one year before the date

novinosrin — Thu, 14 Jan 2021 00:13:59 GMT


data have;
input ID DOB :ddmmyy10.;
format dob ddmmyy10.;
cards;
1   09/07/2003

2  10/03/2004

3  08/08/2003
;

data want;
 set have;
 want =intnx('year',dob,-1,'s');
 format want ddmmyy10.; 
run;