datasets

[manya92]

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 ?

[Tom]

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;