Dear All, I am working on a large confidential healthcare data set. I am trying to make cost estimation based on it. In my dataset, there are cancer patients with survival info and their monthly cost. I will subtract patients' own pre-diagnosis monthly costs from post-diagnosis monthly cost to estimate cancer related cost I have postdiagnosis cost of patients until death (therefore number of months covered after diagnosis is different for each patients) but I have 12 month prediagnosis cost for each patients. I am planning to make subtraction based on the following logic: Let us think about only one patient: 1. If this patient survives less than or equal to 12 months, I will subtract cost in each prediagnosis month from each postdiagnosis month: cancer cost(i)=postdiagnosiscost(i)-prediagnosis cost(i), i=1,...,S S=number of months survived. 2. If patient survives more than 12 months, I will subtract cost in each prediagnosis month from each postdiagnosis month according to mod 12: cancer cost(i)=postdiagnosis cost(i)-prediagnosis cost(j), i=1,..,S j=mod(i), S=number of months survived. Let the patient live 26 months: For cancer cost at 15th month I will have: cancercost(15)=postdiagnosis cost(15)-prediagnosis cost(3), For cancer cost at 25th month I will have: cancercost(25)=postdiagnosis cost(15)-prediagnosis cost(1) I merged these two datasets (prediagnosis and postdiagnosis cost) but I have missing values because I have only 12 months of prediagnosis cost and postdiagnosis cost for more than 12 months. I want to fill in missing values of prediagnosis cost by replicating them according to mod of survival of patients. Can you help me in writing macro or code of this problem? Thank you.
... View more