I have the following data: data have; input id var_1 $ var_2 flag_1 flag_2; datalines; 1 ab 1 0 1 1 ab 1 0 1 1 ab 1 0 0 1 ab 1 0 0 1 ef 7 1 0 1 ef 7 0 0 1 ef 7 1 0 2 ef 3 1 1 2 xy 4 1 0 2 xy 4 1 0 2 xy 4 1 0 2 xy 5 0 1 2 xy 5 0 1 ; run;   I want to create a table like below:    ID Var_1 Var_2 Flag_1_new Flag_2_new 1 ab 1 0 1 1 ef 7 1 0 2 ef 3 1 1 2 xy 4 1 0 2 xy 5 0 1   Here for each ID, Var_1, and Var_2 combination, I am trying to create one Flag_1_new and one Flag_2_new. The value of this Flag_1_new will be 1 if any of the observation for that group has a flag_1 value of 1 (else 0). Need to repeat the same for Flag_2_new.   I hope someone can help me to find a solution. Thanks in advance!   ... View more

data have; input ID Sex Year Region $ Group Condition; datalines; 1 1 2015 North 1 1 2 0 2015 North 2 1 3 0 2015 South 3 1 4 1 2015 South 1 1 5 0 2015 South 2 1 6 1 2015 East 3 1 7 1 2016 East 1 1 8 1 2016 East 2 1 9 0 2016 North 3 1 10 0 2017 North 1 1 11 0 2017 South 2 0 12 1 2017 South 3 0 13 1 2018 South 1 0 14 1 2018 South 2 0 15 0 2018 South 3 0 16 1 2018 South 1 0 17 1 2018 North 2 0 18 1 2018 North 3 0 19 0 2018 West 1 0 20 0 2018 West 2 0 ; run;   I am trying to create a table like below:     Year       2015 2016 2017 2018 Total Sex 1 3 (50%) 1 (33%) 2 (67%) 3 (37.5%) 9 (%)   0 3 (50%) 2 (67%) 1 (33%) 5 (62.5%) 11 (%) Reagion North 2 (33%) 1 (33%) 1 (33%) 2 (25%) 6 (30%)   South 3 (50%) 2 (67%) 2 (67%) 4  (50%) 11 (55%)   East 1 (17%) 0 (0%) 0 (0%) 0 (0%) 1 (5%)   West 0 (0%) 0 (0%) 1 (0%) 2 (25%) 3 (15%) Group 1 2  (33%) 1 (33%) 1 (33%) 3 (37.5%) 7 (35%)   2 2  (33%) 1 (33%) 1 (33%) 3 (37.5%) 7 (35%)   3 2 (33%) 1 (33%) 1 (33%) 2 (25%) 6 (30%) Condition  1 6 (100%) 3 (100%) 1 (33%) 0 (0%) 10 (50%)   0 0 (0%) 0  (0%) 2 (67%) 8 (100%) 10 (50%)   I can get the numbers by using separate PROC FREQ procedures. Is there any way to get the entire table using a single procedure?   Thanks in advance! ... View more

data a1; input ID date :date9. Supply; format date date9.; datalines; 1 03JAN19   90 2 02JAN19   30 2 15FEB2019 30 3 02JAN19   30 3 05JAN19   -30 3 30MAR19   30 4 03APR19   60 5 01FEB19   60 5 02FEB19   60 5 06FEB19   -60 6 01MAR19   30 6 01APR19   30 ;   I am trying to delete pairs of observations where a negative value of supply appears within 7days of a positive value (the FIRST AND SECOND OBSERVATION of ID 3 and SECOND AND THIRD OBSERVATION of ID 5 in this example), considering the second observations are actually a refund of the earlier observation. I have a code which is deleting all observations in a 7day window. In this example the code is deleting FIRST, SECOND AND THIRD OBSERVATIONS of ID 5. I need a code that deletes only the positive-negative pairs (to keep the first observation for ID 5).   Thanks in advance for the help.   ... View more

I have the data in following format: ID Date Supply Pay Visit 1 03JAN19 90 90 1 2 02JAN19 30 30 1 2 15FEB2019 30 30 2 3 02JAN19 30 30 1 3 05JAN19 -30 -30 2 3 30MAR19 30 30 3 4 03APR19 60 60 1 5 01JAN19 60 60 1 5 02FEB19 60 60 2 5 06FEB19 -60 -60 3 6 01MAR19 30 30 1 6 01APR19 30 30 2   I want to delete negative claims dollar amount and negative supply in this data (the FIRST AND SECOND VISIT of ID 3 and SECOND AND THIRD VISIT of ID 5 in this example), considering the second observations are actually a refund or reversal of the earlier observation (reversal within 7days of a visit). Thanks in advance for the help.     data a1; input ID date date9. Supply Pay Visit; format date date9.; datalines; 1     03JAN19     90    90    1 2     02JAN19     30    30    1 2     15FEB2019   30    30    2 3     02JAN19     30    30    1 3     05JAN19     -30   -30   2 3     30MAR19     30    30    3 4     03APR19     60    60    1 5     01JAN19     60    60    1 5     02FEB19     60    60    2 5     06FEB19     -60   -60   3 6     01MAR19     30    30    1 6     01APR19     30    30    2 ; ... View more