Hello, I got stuck with this coding and would appreciate any help. I am interested in find the initial/first ever cancer diagnosis (Ischemic Stroke or Hemorrhagic Stroke), the date of initial diagnosis. Then I want to find if there a recurrent dx of ischemic or Hemorrhagic Stroke and create a label for it as recurrent if it occurred after the initial/first cancer diagnosis. For Atrial Fibrillation (AFIB), I want to create a label for each ICD code and label the encounter as pre/post initial stroke depending on the encounter date and initial stroke date. I want to pull data for seizure diagnosis and create a label for each ICD code and label the encounter as “post” initial stroke. Ischemic Stroke ICD 9 codes: 433, 434, 436, I63, I693, G459 Hemorrhagic Stroke ICD 9 codes: 430, 431, 4320, 4321, 4329, I60, I61, I62 Recurrent Ischemic Stroke ICD 9 codes: 435, 436, 433, 434, I60 – I64 AFIB ICD9/10: 42731, I480, I481, I482, I489 Seizure ICD 9/10: 345, 78039, 345, 6494, G40   data have; infile datalines dsd; informat ID diag_dt dx1 dx2 dx3 dx4; input ID $ 1-7 @8 diag_dt :date9. dx1 $ 18-23 dx2 $ 24-29 dx3 $ 30-35; informat diag_dt date9.; format diag_dt date9.; datalines; 0036059 02AUG2023 G459 I4729 I10 0036059 23JUN2023 G459 R29810 I6782 0036059 28JUN2023 Z8673 G459 0036059 14SEP2023 G459 Z8673 0068059 19OCT2009 436 0095408 04AUG2023 A419 I253 K625 0095408 26JUL2021 G459 0095408 22APR2024 I6389 Q2112 0114279 10JUL2003 430 7843 7820 0114279 11JUL2003 74781 431 0114279 16JUL2003 431 74781 0114279 10JUL2003 431 7820 0114279 17JUL2003 4329 0126660 04OCT2006 30924 4321 30742 0126660 18SEP2006 4321 0126660 25SEP2006 4321 0126660 16OCT2006 V679 8509 4321 0204855 09SEP2009 436 78609 V681 0324626 20JUN2002 436 7843 34211 0324626 21JUN2002 436 0324626 01AUG2002 436 0346276 30NOV2009 431 5849 4010 0346276 02DEC2009 431 0222626 01AUG2002 433 0222626 30NOV2009 433 5849 4010 0222626 02DEC2009 G40 6494 ; run; ... View more

Hi, I am trying to achieve a specific sort order using custom sort for the variables Names and Codes. I have a sample variable with this order below: Names    Codes Boys        2795                  2796                  2900                  PHA                  Total Girls        2795                  2796                  2900                  PHA                 Total Dads      2795                 2796                 2900                 PHA                Total Moms   2795                2796                2900                PHA                Total   This is the order I wanted Names  Codes Dads      PHA                 2795                 2796                 2900                 Total Moms    PHA                 2795                 2796                 2900                Total Boys      PHA                2795                2796                2900               Total Girls     PHA               2795               2796               2900               Total   ... View more

Hello all,  I have initially posted this inappropriately, am sorry. I am creating a better representation of the issue so I can get help on this.  I have a dataset with category (teachers, students) and a list of forms (form2, event46, case32) which they are expected to fill within 60days after the school resume. Event46 has a group variable (grp=A, B, C). That is someone can be in any of the group. Among the teachers and students, some did not fill the form (0), some filled the form within 30 days (1), and some filled the form within 60 days (2).  The 0,1,2 represents the days that the form was filled below: No form filled=0 Form filled within 0-30days=1 Form filled within 31-60days=2   This is what I want   Table 1:  1. If a teacher or student only filled form2 within 30days and did not fill event46 or case32 they should be in the form2 only column. Same apply for other forms. If they filled the form after 30 days, they will be in the 31-60 days count by category.  2. If anyone filled more than one(1) forms either within 30 days or within 60 days or both, they should be in the multiple column.   Table 2: 3. Finally, I want a total of those who did not fill any form in both category(teacher or student).   I have created a sample output and a demo dataset. Thanks so much for your help. data have; input category $ form2 case32 event46 grp $; datalines; Teacher 1 0 0 . Student 1 0 0 . Teacher 0 1 0 . Teacher 1 0 1 A Teacher 0 0 1 C Teacher 0 0 1 B Teacher 1 0 0 . Student 0 1 1 C Student 0 0 1 C Student 0 0 1 C Student 1 0 0 . Student 0 1 0 . Student 0 2 0 . Teacher 1 1 1 B Teacher 0 0 2 A Teacher 0 0 2 B Teacher 2 0 0 . Student 0 1 1 C Teacher 0 0 0 . Student 0 0 0 . Student 0 0 1 B Teacher 0 0 1 B Teacher 0 2 0 . Teacher 2 2 0 . Student 0 1 0 . Teacher 2 0 1 A Student 0 0 1 A Teacher 0 0 0 . Student 2 0 0 . Teacher 0 0 2 C Student 0 0 2 C Student 0 0 2 B Student 0 0 2 A ; run; The expected output should look like this:   Form2 only Case32 only Event46 A only Event46 B only Event46 C Only Multiple Total Teacher fill form within 0-30 days               Teacher fill form within 31-60 days               Student fill form within 0-30days               Student fill form within 31-60days               Total                    Total Teacher who did not complete any form within 0-60 days   Student who did not complete any form within 0-60 days   Total     ... View more