05-15-2018 12:05 PM
my data set : derived.pt_cohort contains information on the patient level but i need to create another data stet based on derived._cohort which is at treatment line level, so i need multiple rows for one patient with different lines of treatment . But i have to use the derived.pt_cohort data set since i have already added all the criteria for my cohort in this data set, how do i do this ?
05-15-2018 12:18 PM
Where are you getting the treatment information?
You should probably just merge the two tables.
data derived.treatment ; merge derived.pt_cohort (in=in1) raw.treatment ; by ptid ; if in1 ; * other logic ; run;