Hello everyone, I have a dataset like in the table below. Please, how do I create pre_cost and post_cost variables such that their values are the sum of costs corresponding to the pre-era (1) and post-era (2) respectively? Thank you so much. id pre_post_period cost pre_cost post_cost 001 1 50 150 50 001 1 100 150 50 001 2 50 150 50 002 1 150 350 75 002 1 200 350 75 002 2 30 350 75 002 2 45 350 75 ... View more

Hello all,   I found a solved question relating to identifying gaps in therapy (https://communities.sas.com/t5/SAS-Programming/Data-cleaning-for-Cox-regression-analysis/td-p/730972). I have a similar problem but I don't know how to: 1. create the days and days_int variables. 2. censor patients whose dose changed. I appreciate your assistance. Thank you ID Dose Med_start_date Days Days_int 1 2 01JAN2015 0 . 1 4 16JAN2015 15 15 2 2 01JAN2010 0 . 2 4 11APR2010 100 100 3 8 01JAN2012 0 . 3 16 31JAN2012 30 30 3 24 10MAY2012 130 100 4 8 01MAR2017 0 . 4 8 30APR2017 60 60 4 8 29JUN2017 120 60 4 16 28AUG2017 180 60 4 16 27OCT2017 240 60 5 8 01FEB2018 0 . 5 8 02APR2018 60 60 5 16 01JUN2018 120 60 5 16 21JUL2018 170 50 5 32 20AUG2018 200 30 5 32 18NOV2018 300 90 6 1 01JAN2011 0 . 6 2 20FEB2011 50 50 6 2 21APR2011 110 60 6 4 20JUN2011 170 60 6 6 18SEP2011 260 90 7 8 01JAN2019 0 . 7 16 28OCT2019 300 300 ... View more

Hello everyone, I need your help please: I want to calculate the average daily dose (ADD) for each patient (= quantity_supplied/days_supplied) for the first 6 months of prescription fills (fill_date), such that for each patient, I have a single value of ADD that corresponds to the average number of tablets they took per day from the first time they received the medication (index date) till up to 6 months. Your help will be greatly appreciated. Thank you patient_id fill_date index_date quantity_supplied days_supplied 1 01/11/2018 01/11/2018 140 30 1 01/12/2018 01/11/2018 140 30 1 01/22/2018 01/11/2018 160 30 1 02/16/2018 01/11/2018 90 90 1 03/19/2018 01/11/2018 90 90 1 06/18/2018 01/11/2018 90 90 2 02/12/2017 02/12/2017 120 30 2 03/23/2017  02/12/2017 120 30 2 06/14/2017  02/12/2017 90 90 2 07/30/2017  02/12/2017 90 90 2 08/31/2017  02/12/2017 60 60 ... View more

Hello everyone,  I have two variables: start_year and end_year. start_year is in recorded in years and in format numeric 8. while end_year is mmddyy10. i have tried to subtract and get the age but i keep getting funny values even with some of the codes i found. Attached is the simplest code i tried, your help is highly appreciated. sample data. start_date (8.)  end_date(mmddyy10.) 2015                01/02/2017 2013                05/07/2014 2018                06/06/2019 data want; set have; format end_date year4.; end_date2 = end_date; format end_date2 8.; age = end_date2 - start_date; run; ... View more