Trying to calculate the total number of days between cases of "Debridement" by study number.    Data Have: Studynum            Proc1                         Procedure Date 4                          Debridement            09SEP13:15:34:00 4                          Debridement            12SEP13:14:45:00 4                           Debridement           20SEP13:20:22:00 5                         Debridement              25OCT14:13:01:00 5                         Debridement              26OCT14:15:01:00   Data Want: Studynum        Total Days Between Cases of Debridement 4                        5.3  5                        2.1                  ... View more

Trying to code data so I can count the number of times the phrase "Medicare" appears in the insurance type listed. I used the index only to see that it counts where in the phrase it occurs for example, Secondary Medicare, was counted as 11. Is there any way to eliminate the characters that appear before Medicare so I can create a variable that properly counts the number of patients with any type of Medicare insurance?     This was the original code I used: data test; set insurance; Medicare = index (Insurancetype,'Medicare'); run;     data have:   Studyid     Insurancetype                                        Medicare 3548           Medicare                                                   1 6789            Managed Medicare                                  9 4567             Auto Generic/Secondary Medicare        25   data want: Studyid     Insurancetype                                        Medicare 3548           Medicare                                                   1 6789            Managed Medicare                                  1 4567             Auto Generic/Secondary Medicare         1   ... View more

Hello,      I have a dataset that shows the type of procedure, listed under proc1 and the ID (studynum). Each studynum may have several different types of procedure/procedure groups that occurred on different dates. I want to count each type of observation by patient.   Data have: Studynum      Proc1                      Proc date 1                  Debridement             8/18/15 1                   Other                       9/8/15  1                   Other                       8/3/15 1                   Woundvac                8/4/15 1                   Debridement            8/4/15 2                   Amputation              10/5/15 2                   Other                      10/6/15 2                   Other                       10/7/15   Data Want: Studynum    Debridement      Other       Woundvac     Amputation 1                         2                    2                  1                     0 2                         0                    2                  0                     1 ... View more

data have:    StudyNum Response ScoreAssessment Assessment AssessmentDT 1233 Y   Frailty 7/8/18 6:00 1233 N   Dementia   1096   2 Frailty   1236 N   Dementia   1236 Y 3 Frailty 7/11/18 3:00 1253 Y 4 Frailty 8/9/18 5:00 data want:  each study number has a response, a score assessment, an assessment, and an assessment DT long ways. Is there a macro code to transpose those variables so I don't have to do several transpose steps? ... View more