Hello All,   I have claims dataset and want to see most frequent Health Plan of the year for each patient who have health plans assigned for each month. In case if some one have two or more health plans with same frequency e.g. patient patient ID 3 in my example I would like to assign the latest health plan.   data have; input id 1 hp_01 $ 3-5 hp_02 $ 7-9 hp_03 $ 11-13 hp_04 $ 15-17 hp_05 $ 19-21 hp_06 $ 23-25 hp_07 $ 27-29 hp_08 $ 31-33 hp_09 $ 35-37 hp_10 $ 39-41 hp_11 $ 43-45 hp_12 $ 47-49; datalines; 1 MCO MCO MCO PPO PPO PPO PPO PPO PPO PPO PPO PPO   2 PDP PDP PDP PDP PDP PDP PDP PDP PDP PDP MCO MCO 3 EDP EDP EDP EDP EDP EDP PPO PPO PPO PPO PPO PPO 4 MCO MCO MCO MCO MCO MCO MCO MCO MCO EDP EDP EDP 5 EDP EDP EDP EDP MCO MCO PPO PPO PPO PPO EDP EDP 6 MCO NET NET NET EDP EDP NET NET MCO MCO MCO MCO 7 PPO PPO PPO NET NET NET NET NET PPO PPO MCO MCO 8 EDP MCO MCO MCO PPO PPO PPO PPO PPO NET NET NET 9 NET NET NET NET PPO PPO PPO PPO PPO PPO PPO PPO ;   Thank you for help in advance. ... View more

Hello SAS Gurus,   I am stuck again and need your help. I am working with prescription claims dataset and looking at adherence of a certain class of drugs in each patient. I am looking if the patients are filling this certain drug class for 84 days or more after the first fill but I also have a certain duration which is 114 days from the first prescription date (if we include the first prescription date this duration is 115 days).   Data set I have: ID          First_Pres_Dt             Pres_Dt                              DAYS_SUPP 1             10OCT2022                10OCT2022                      30 1             10OCT2022                 26OCT2022                     30 1             10OCT2022                 30DEC2022                     30 1             10OCT2022                 01FEB2023                       30 1             10OCT2022                 11APR2023                       30 2            11AUG2022                   11AUG2022                      30 2            11AUG2022                   12SEP2022                       30 2             11AUG2022                  19DEC2022                      30 2              11AUG2022                 22JAN2022                      30 3              17AUG2022                 17AUG2022                      30 3               17AUG2022                 14SEP2022                      60 3              17AUG2022                  11DEC2022                       15 4              04OCT2022               04OCT2022                     15 4              04OCT2022               01NOV2022                      30 4              04OCT2022               15NOV2022                       30 4             04OCT2022                21JAN2023                        30   In the above dataset, if you look at ID 4, this pt. has first fill on 4th Oct 2022 and if I will add 114 days the date will be 26th Jan 2023. So this patient has to have at least 84 days of fill till 26th Jan 2023. But he is not meeting the criteria as he only has 81 days of fill (15+30+30+6), the last fill I am including only 6 days as his window is only up to 26th Jan 2023.  So pt. 4 is not meeting the criteria but rest of patients are meeting this criteria. Hope the explanation helps.   Thank you    ... View more