Hi - I am trying to count the number of medications in this sample data by id and within 90 days from the start date for each prescription. For example: take the first record, add 90 days to get the end date as 04/19/12. Now start counting # of meds (med_cnt) until the start date reaches this end date 04/19/12, then go to the next record and start over again until last.id. Any help is greatly appreciated! Here is the sample data: data med; input id $ start_dt:mmddyy8. med; cards; 001 01/20/12 1 001 01/31/12 1 001 02/17/12 1 001 04/25/12 1 002 02/02/12 1 002 05/01/12 2 ; The output would be something like this: id        start_dt     med     end_dt     med_cnt 001     01/20/12     1     04/19/12     1 001     01/31/12     1     04/30/12     2 001     02/17/12     1     05/17/12     3 001     04/25/12     1     07/24/12     3   ==> as soon as start date 4/5 > the first end date 4/19, then go to the 2nd observation and start again. 001     10/11/12     1     01/09/14     1 002     02/02/12     1     05/03/12     1 002     05/01/13     2     07/30/12     3 ... View more

Hi everyone - I am trying to add multiple text strings onto a single record. From something like this: ID           TEXT_1        TEXT_2 001         aaaaa          bbbbb 002         ccccc          ddddd Here is what I'd like to achieve: ID          TEXT_3 001        aaaaa              bbbbb 002        ccccc              ddddd Any help would be greatly appreciated. Thanks, ... View more

I have been trying to get this input: ID     VAR_1       VAR_2      VAR_3 001      1                              3     001                    2 002                    2 002    1 002                     2               3 To this output: ID     VAR_1       VAR_2     VAR_3 001     1               2               3 002     1               2               3 Here is my test dataset. I used RETAIN to get them all line up at the end, then take the LAST.ID. However the retain does not seem to work... data a; input id $ 1-3 var_1 $ 4-4 var_2 $ 5-5 var_3 $ 6-6; cards; 0011 3 001 2 002 23 0021 002 3 ; Any ideas. Thanks! -K ... View more