🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 01-13-2021 06:46 PM
(1543 views)
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.
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;