Hello SAS Community, I am attempting to compare dates for reporting purposes. I am using SAS 9.3. For this case, I have a list of subjects with dates (date9. format) like so: Name CompareDate Date1 Date2 Date3 Bob 09-04-1993 06-21-1992 10-23-1990 01-21-1991 Alice 01-30-2014 05-07-2003 02-02-2015 05-15-2016 Sam 10-05-1989 04-17-1982 12-23-1988 09-07-1985 Mark 02-22-2013 06-01-1997 04-02-2001 Adam 05-23-1996 10-14-1992 03-15-1994 02-16-1991 Dan 11-12-2005 07-06-2002 04-23-2000 12-24-2007 Sandy 03-07-2000 12-04-1993 08-09-1994 04-01-1996 I would like to compare Date1-Date3 with CompareDate, and output any subjects with related dates that occur after it. Note that Mark does not have any value for CompareDate - in this case, he would be ignored in this comparison. Otherwise, it would Alice with 02-02-2015 and 05-15-2016, and Dan with 12-24-2007. The output would be something like: Name Compare Date Date VarName Alice 01-30-2014 02-02-2015 Date2 Alice 01-30-2014 05-15-2016 Date3 Dan 11-12-2005 12-24-2007 Date3 To start, I created a macro variable with CompareDate but I am not sure if it will work across multiple subjects. Can someone please point me in the right direction? Please let me know if you need further clarification. Thank you in advance, Yawen
... View more