Hello,  I have the following data table below.  I only want to keep the first 3 observation output for each ID and Measure.  Any help would be greatly appreciated.  Thank you!   data have; input ID Measure Date :mmddyy10. Output; format date mmddyy10.; datalines; 1 A 010117 1 1 A 020117 2 1 A 030117 3 1 A 060118 1 1 A 070118 2 1 A 080118 3 2 A 010116 1 2 A 020116 2 2 A 030116 3 3 A 010116 1 3 A 020116 2 3 A 030116 3 3 B 010116 1 3 B 020116 2 3 B 030116 3 data want; input ID Measure Date :mmddyy10. Output; format date mmddyy10.; datalines; 1 A 010117 1 1 A 020117 2 1 A 030117 3 2 A 010116 1 2 A 020116 2 2 A 030116 3 3 A 010116 1 3 A 020116 2 3 A 030116 3 3 B 010116 1 3 B 020116 2 3 B 030116 3     ... View more

Hello,   I have the following data table:   ID Measure Number Date Flag Output 1 A 5 11/1/2014 1 3 1 A 1 12/1/2014 1 3 1 A 3 1/1/2015 1 3 1 A 5 10/1/2015 1 5 1 A 6 11/1/2015 1 5 1 A 8 12/1/2015 1 5 1 A 3 1/1/2016 1 5 1 A 6 2/1/2016 1 5 1 A 1 8/1/2017 1 6 1 A 6 9/1/2017 1 6 1 A 10 10/1/2017 1 6 1 A 2 11/1/2017 1 6 1 A 14 12/1/2017 1 6 1 A 5 1/1/2018 1 6   I am trying to select the output variable with the greater output number, but earlier time period.  For example, the output '5' is greater than '3', but the date is earlier than the output '6', so I would select that.  However, I'm not sure how to write this coding.  Eventually, I want to be able to select the following data only from the above table.   ID Measure Number Date Flag Output 1 A 5 10/1/2015 1 5 1 A 6 11/1/2015 1 5 1 A 8 12/1/2015 1 5 1 A 3 1/1/2016 1 5 1 A 6 2/1/2016 1 5   Thank you for any help in advance. ... View more

Hello,   I am having trouble getting the highest count of consecutive data for my dataset.  Here's an example of my data:   ID Appt Year Month 1 A 2014 10 1 A 2014 11 1 A 2014 12 1 B 2015 1 1 B 2015 2 1 B 2015 3 1 B 2015 4 2 A 2014 10 2 A 2014 11 2 A 2014 12 2 A 2015 1 2 A 2015 2 2 B 2016 1 2 B 2016 2 2 B 2016 3 2 B 2016 4       The code I am using is below, but I am not getting the results that I want.  Since an ID can have multiple consecutive appointment times, I need to only take the highest consecutive count.  With the code below, I am getting the following data:   ID Appt Year Month Consecutive 1 A 2014 10 1 1 A 2014 11 2 1 A 2014 12 3 1 B 2015 1 4 1 B 2015 2 5 1 B 2015 3 6 1 B 2015 4 7 2 A 2014 10 1 2 A 2014 11 2 2 A 2014 12 3 2 A 2015 1 4 2 A 2015 2 5 2 B 2016 1 6 2 B 2016 2 7 2 B 2016 3 8 2 B 2016 4 9                    However, I want the following table to be produced:   ID Appt Year Month Consecutive 1 A 2014 10 1 1 A 2014 11 2 1 A 2014 12 3 1 B 2015 1 1 1 B 2015 2 2 1 B 2015 3 3 1 B 2015 4 4 2 A 2014 10 1 2 A 2014 11 2 2 A 2014 12 3 2 A 2015 1 4 2 A 2015 2 5 2 B 2016 1 1 2 B 2016 2 2 2 B 2016 3 3 2 B 2016 4 4   Then, ideally I would only want the final table with the highest consecutive count:   ID Appt Year Month Consecutive 1 B 2015 1 1 1 B 2015 2 2 1 B 2015 3 3 1 B 2015 4 4 2 A 2014 10 1 2 A 2014 11 2 2 A 2014 12 3 2 A 2015 1 4 2 A 2015 2 5       data TestD (KEEP = ID Appt Year Month Consecutive); SET TestC; BY ID Appt; RETAIN Consecutive; IF First.ID or First.Appt THEN Consecutive = 0; ELSE Consecutive = Consecutive +1; IF Consecutive GT 0 THEN OUTPUT; run;   Thank you for your help in advance! ... View more

Hello,   I have the following table: ID Date Rating 1 Jan-14 High 1 Feb-14 High 1 Mar-14 Low 2 Jan-14 Low 2 Feb-14 Low 3 Jan-14 High 3 Feb-14 High 4 Jan-14 Low 4 Feb-14 Low 4 Mar-14 High 4 Apr-14 High 5 Jan-14 Low   I am trying to create a count of the Ratings by Month to create the following table:   Jan-14 Feb-14 Mar-14 Apr-14 Total High 2 2 1 1 6 Low 2 2 1 0 5 Total 4 4 2 1 11     Any help would be greatly appreciated.   Thank you in advance. ... View more