Hi there! @echoli, in the end, did you find a solution? I know it has been a while since the last post but I am facing the exact same problem and don't know how to do so if you have a hint, I would be very interested 🙂 P.S.: Please be kind, I am a SAS newbie 🐥   ... View more

Thanks a lot. It was very useful. ... View more

Link to New topic   ... View more

If the ID is not duplicated in either set then this may do what you want; /* data step merge by requires sorted data*/ proc sort data=a; by id; run; proc sort data=b; by id; run; data want; merge b a; by id; run; Sorts included even though example data already sorted just in case.   ... View more

As shown below, after adding the new records you mentioned, that new case results in NOT being identified as being SERIOUS, so I'm not sure what you ran.   In the code below, I made the changes that would be needed to accomodate your changed requirement (i.e., more than 4 months rather than four months or more):   data abc; informat date mmddyy10.; informat time anydtdtm16.; input ID Date time; format date mmddyy10. time MDYAMPM.; datalines; 14022 6/22/2010 10/11/2004 9:02 14022 6/22/2010 3/25/2008 12:53 14022 6/22/2010 4/29/2008 9:04 14022 6/22/2010 6/17/2008 9:14 14022 6/22/2010 7/8/2008 10:41 14022 6/22/2010 8/12/2008 12:30 14022 6/22/2010 9/16/2008 14:24 14022 6/22/2010 10/21/2008 1:44 14022 6/22/2010 11/18/2008 2:11 14022 6/22/2010 12/30/2008 9:53 14022 6/22/2010 2/10/2009 13:07 14022 6/22/2010 4/7/2009 9:45 14022 6/22/2010 6/2/2009 7:35 14022 6/22/2010 7/28/2009 10:11 14022 6/22/2010 9/29/2009 10:46 14022 6/22/2010 12/1/2009 10:51 14022 6/22/2010 1/26/2010 8:49 14022 6/22/2010 5/23/2010 7:48 14022 6/22/2010 6/22/2010 7:46 14032 2/7/2012 7/24/2002 10:25 14032 2/7/2012 1/21/2003 12:00 14032 2/7/2012 1/28/2003 9:25 14032 2/7/2012 1/29/2008 9:00 14032 2/7/2012 3/20/2008 13:52 14032 2/7/2012 5/1/2008 8:53 14032 2/7/2012 6/12/2008 14:01 14032 2/7/2012 7/24/2008 15:00 14032 2/7/2012 9/11/2008 11:02 14032 2/7/2012 9/20/2011 9:25 14032 2/7/2012 11/1/2011 10:40 14032 2/7/2012 1/8/2012 12:58 14032 2/7/2012 2/7/2012 10:20 14032 2/7/2012 3/7/2012 9:18 14032 2/7/2012 5/15/2012 12:43 14032 2/7/2012 6/19/2012 9:19 14032 2/7/2012 7/31/2012 11:48 14032 2/7/2012 9/18/2012 12:15 14032 2/7/2012 10/16/2012 12:35 14032 2/7/2012 10/18/2012 11:12 14032 2/7/2012 10/19/2012 5:00 14032 2/7/2012 10/20/2012 4:33 14032 2/7/2012 10/21/2012 4:19 14032 2/7/2012 10/22/2012 4:30 14032 2/7/2012 10/23/2012 5:03 14032 2/7/2012 10/24/2012 3:14 14032 2/7/2012 10/30/2012 11:10 14032 2/7/2012 11/27/2012 12:30 14032 2/7/2012 1/8/2013 9:58 14032 2/7/2012 2/19/2013 10:07 14032 2/7/2012 4/2/2013 13:45 14032 2/7/2012 5/14/2013 10:18 14238 2/7/2012 5/21/2007 10:18 14238 2/7/2012 6/14/2007 10:18 14238 2/7/2012 7/12/2007 10:18 14238 2/7/2012 7/15/2009 10:18 14238 2/7/2012 7/16/2009 10:18 14601 1/30/2014 4/26/2005 8:40 14601 1/30/2014 6/28/2005 9:05 14601 1/30/2014 7/26/2005 8:21 14601 1/30/2014 8/9/2005 8:24 14601 1/30/2014 8/23/2005 8:10 14601 1/30/2014 10/18/2005 9:20 14601 1/30/2014 12/29/2013 9:32 14601 1/30/2014 12/30/2013 9:04 14601 1/30/2014 2/16/2014 8:44 14601 1/30/2014 5/2/2006 10:31 14601 1/30/2014 7/12/2006 7:31 14601 1/30/2014 9/7/2006 8:55 14601 1/30/2014 10/31/2006 8:43 14601 1/30/2014 2/6/2007 9:15 14601 1/30/2014 5/3/2007 7:54 14601 1/30/2014 6/28/2007 7:52 14601 1/30/2014 8/23/2007 8:10 14601 1/30/2014 10/18/2007 8:17 14601 1/30/2014 11/19/2007 2:07 14601 1/30/2014 12/13/2007 8:16 14601 1/30/2014 1/24/2008 10:23 14601 1/30/2014 1/31/2008 10:07 14601 1/30/2014 2/12/2008 12:31 14601 1/30/2014 3/25/2008 9:52 ; run; data want (drop=stack:); retain stack0-stack4; array stack(0:4) stack0-stack4; length serious $3; do until(last.id); set abc; by id; if first.id then do; serious='No'; n=1; call missing(of stack(*)); end; else n+1; stack(mod(n,5))=time; if n ge 5 and serious='No' then do; if yrdif(datepart(min(of stack(*))),datepart(max(of stack(*))),'age') le 1 then serious='Yes'; end; end; do until(last.id); set abc; by id; output; end; run; Art, CEO, AnalystFinder.com ... View more

That is a normal message from proc sql. It doesn't mean that there was a problem.   However, since it didn't select any rows, it indicates that you don't have any records that meet the condition that you specified.   You'd have to post some of your actual data for us to understand.   Are you sure that event_end_UA is a date, rather than a datetime variable?   Art, CEO, AnalystFinder.com   ... View more

Try specifying CYCLEATTRS on the SGPLOT procedure statement and see if that gives you what you want.   Hope this helps! Dan ... View more