I have a data set where a patient and their claim dates, I want to flag the date which is the index disease date. Logic is that the patient must have at least 2 claim with-in 30 days to confirm the patient has the disease (A, B, C have disease). Next, we want to identify the Index date, which is not same as the min date of the patient (ex: Patient B's 1st claim doesn't meet our disease condition as no. of claims between 05/01 and 30days is only 1).   Have: PatientID Dates A  01/01/2018 A 01/03/2018 A 03/01/2018 A 03/03/2018 B 05/01/2018 B 07/02/2018 B 07/05/2018 C 06/07/2018 C 06/13/2018   Want: PatientID Dates Flag A  01/01/2018 Index A 01/03/2018 Treatment A 03/01/2018 Treatment A 03/03/2018 Treatment B 05/01/2018 Screening B 07/02/2018 Index B 07/05/2018 Treatment C 06/07/2018 Index C 06/13/2018 Treatment ... View more

Hello,   I've done a propensity score matching for case and control using variables like disease comorbidities etc. Now, my goal is to calculate the incremental cost (Difference of the average) between case and control, when I look at the cost data for case and control both doesn't follow normal distribution (Right Skewed). I know there are tests to do check for normal distribution, I would like to do diagnostic test to understand the type of distribution the data is following, like log, gamma etc. and use the appropriate distribution to calculate average.   I would really appreciate if someone can help me with process of how to do diagnostics, transform to the appropriate distribution and get the incremental average cost difference.    I've attached the dataset with following variables Paid_ID: Matched Pair VLU: '1' for Case, '0' for Control Post_Cost: Cost data Proc_score: Propensity score   I'm using SAS 9.3, so I would appreciate if you could guide me the process in the version.   Thanks       ... View more