Hi SAS users,
I have a dataset with 3 variables: ID, date1 and date2. I would like to create a new dataset that identifies which observations have a date2 that is 5 months or greater than date1. For example using the data below, I would like to identify IDs 7 and 11 as they have a date2 that is at least 5 months greater than date1.
Thanks.
data have;
input id date1 date2;
cards;
5 05/12/2010 06/12/2010
7 06/22/2010 12/30/2010
9 02/04/2009 05/03/2009
11 03/27/2009 11/05/2009
;
run;
try this one:
data have;
informat date1 date2 mmddyy10.;
format date1 date2 mmddyy10.;
input id date1 date2;
cards;
5 05/12/2010 06/12/2010
7 06/22/2010 12/30/2010
9 02/04/2009 05/03/2009
11 03/27/2009 11/05/2009
;
data want;
set have;
if date2>intnx('month',date1,5,'s');
proc print;run;
Linlin
Thanks LinLin! Always very helpful!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.