Hi SAS Community,   I need your help with a problem.   Have       ID Flagdate Startdate Cost         133 17-Jul-13 18-Jul-13 1307.77 133 17-Jul-13 18-Jul-13 96.6 133 17-Jul-13 21-Jul-13 55.74 133 17-Jul-13 22-Jul-13 169.86 133 17-Jul-13 22-Jul-13 58.16 133 17-Jul-13 22-Jul-13 30.51 133 17-Jul-13 28-Aug-13 34.93 133 17-Jul-13 30-Aug-13 0 133 17-Jul-13 30-Aug-13 0 133 17-Jul-13 5-Sep-13 34.93 133 17-Jul-13 20-Sep-13 3.34 133 17-Jul-13 23-Sep-13 83.48 134 18-Jul-13 21-Oct-13 13.11 135 19-Jul-13 25-Oct-13 0 136 20-Jul-13 25-Oct-13 11.5 137 21-Jul-13 25-Oct-13 10.48 138 22-Jul-13 25-Oct-13 217.07 139 23-Jul-13 25-Oct-13 83.48 140 24-Jul-13 25-Oct-13 0 141 25-Jul-13 25-Oct-13 49.59 142 26-Jul-13 25-Oct-13 63.2 143 27-Jul-13 27-Oct-13 20.18 144 28-Jul-13 4-Nov-13 11.49 145 29-Jul-13 7-Nov-13 29.45   The problem I need to solve is to compress the above to accumulate the costs for 30 day intervals by ID. In other words, for first row Intervel_start  = Flag_date or and Intervel_end = Interval_start + 30. For the second row, Interval_start = Previous row Interval_end + 1 and Interval_end = Interval_start+30 and so on for all rows. Once this is done the startdate and cost within these interval ranges need to be accumulated per each range for each ID.    This is the mock output for the above data-set. I have tried using lag function to get the ranges but seems to not work.    Want         ID Flagdate Intervel_Start Intervel_End Cum_Cost 133 17-Jul-13 17-Jul-13 16-Aug-13 1718.64 133 17-Jul-13 17-Aug-13 16-Sep-13 69.86 133 17-Jul-13 17-Sep-13 17-Oct-13 86.82 133 17-Jul-13 18-Oct-13 17-Nov-13 509.55     Thank you for your time and help.   Best, SC.   ... View more

Hi Community,   I have trouble finding a solution for the below problem.   ID E1 E2 E3 E4 E5 Int_start Int_end 1 0 1 1 . 1 2 5 2 0 0 1 1 1 3 4 3 1 1 1 0 0 2 5 4 1 1 1 1 0 1 5 5 1 0 0 0 1 3 5   The above dataset has e1 to e5 array and Intervel_start and Intervel_end. The problem I have is to check the array of the Int_start and Int_end and capture the 0 or . in between the series of 1's .   ID E1 E2 E3 E4 E5 Int_start Int_end Disenr 1 0 1 1 . 1 2 5 e4 2 0 0 1 1 1 3 4 . 3 1 1 1 0 0 2 5 e4 4 1 1 1 1 0 1 5 e5 5 1 0 0 0 1 3 5 e3   The logic of the Disenr variable is that if the array of Int_start and Int_end contains any value other than 1 then I would like to have that variable name in the disenr variable.    Can you help?   Thank you for your time.    Best, SC. ... View more

Hi Community, Thank you for taking time to help.   I have a one row per person dataset with a series of dates- ID Startdate1 Enddate1 Startdate2 Enddate2 1 1-Jan-92 31-Mar-92 1-Aug-99 30-Sep-12 2 1-Apr-93 31-Dec-99     I want to convert this to a format of Enrolled1 to Enrolled312 where Enrolled1 = 1Jan1991 and Enrolled312 = 31Dec2016 (Monthly iteration).  For ID - 1 enrollment ranges from 1-Jan-92 till 31-March-92 and 1-Aug-99 to 30-Sept-12. So the corresponding Enrolled[i] for these months should be = 1 else 0. Can you help with the problem. Thank you for your time. ... View more

Hi SAS Users,   Below is the data I have: ID Startdate Enddate Name 1 26-Sep-13 26-Sep-13 Erloti 1 23-Oct-13 23-Oct-13 Erloti 1 22-Nov-13 22-Nov-13 Erloti 1 16-Dec-13 16-Dec-13 Erloti 1 6-Jan-15 6-Jan-15 Erloti 1 6-Jan-15 6-Jan-15 Erloti 1 11-Feb-15 11-Feb-15 Erloti 1 11-Feb-15 11-Feb-15 Erloti 1 27-Aug-13 27-Aug-13 Erloti 1 20-Sep-13 20-Sep-13 Erloti 1 18-Oct-13 18-Oct-13 Erloti 1 20-Nov-13 20-Nov-13 Erloti 1 18-Dec-13 18-Dec-13 Erloti 1 10-Feb-15 10-Feb-15 Erloti 1 10-Feb-15 10-Feb-15 Erloti 3 1-Apr-14 1-Apr-14 Crizot 3 25-Apr-14 25-Apr-14 Crizot 3 28-May-14 28-May-14 Crizot 3 23-Jun-14 23-Jun-14 Crizot 3 15-Jul-14 15-Jul-14 Ceriti 3 11-Aug-14 11-Aug-14 Ceriti 3 3-Sep-14 3-Sep-14 Ceriti I want to create a flag variable with the below condition if Startdate - Lag(startdate ) > 60 or Name ne Lag(Name) then Flag = 1; I want to create a count variable to have the total count on the Name changes per ID. The final output expectation is below ID Startdate Enddate Name Flag Count 1 26-Sep-13 26-Sep-13 Erloti 0   1 23-Oct-13 23-Oct-13 Erloti 0   1 22-Nov-13 22-Nov-13 Erloti 0   1 16-Dec-13 16-Dec-13 Erloti 0   1 6-Jan-15 6-Jan-15 Erloti 1   1 6-Jan-15 6-Jan-15 Erloti 1   1 11-Feb-15 11-Feb-15 Erloti 1   1 11-Feb-15 11-Feb-15 Erloti 1   1 27-Aug-13 27-Aug-13 Erloti 1   1 20-Sep-13 20-Sep-13 Erloti 1   1 18-Oct-13 18-Oct-13 Erloti 1   1 20-Nov-13 20-Nov-13 Erloti 1   1 18-Dec-13 18-Dec-13 Erloti 1   1 10-Feb-15 10-Feb-15 Erloti 1   1 10-Feb-15 10-Feb-15 Erloti 1 1 3 1-Apr-14 1-Apr-14 Crizot 0   3 25-Apr-14 25-Apr-14 Crizot 0   3 28-May-14 28-May-14 Crizot 0   3 23-Jun-14 23-Jun-14 Crizot 0   3 15-Jul-14 15-Jul-14 Ceriti 1   3 11-Aug-14 11-Aug-14 Ceriti 1   3 3-Sep-14 3-Sep-14 Ceriti 1 2 Thank you your time and expertise.   Have a great day.   ... View more

Hi Community,   I wanted your help in the following issue.   data dsn; input ID $1. Seq $4. Group $5.; cards; 1 01 BC 1 02 BC 2 00 LC 3 01 BC 3 02 LC 4 00 BC 5 01 BC 5 02 KC 5 03 BC 5 04 KC ; run;     I want to delete all the ID's which have group other than BC. Not just the row but all the rows of that ID.   Thank you for your time and Help. ... View more

Hello SAS community,   I would like your help in the following problem.   raw data:-   ID seq Idnum 1 00 01 1 02 05 1 03 04 1 04 05 2 00 01 2 03 01 3 00 01          I would like to recode 00 as 01 when the subsequent code under same ID are >00 and keep the 00 when there are no subsequent codes.   The output can look like this. ID seq Idnum 1 01 01 1 02 05 1 03 04 1 04 05 2 01 01 2 03 01 3 00 01 Thank you for your help.   ... View more