topic Re: datasets in SAS Programming

datasets

manya92 — Tue, 15 May 2018 16:05:51 GMT

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 ?

Re: datasets

Tom — Tue, 15 May 2018 16:18:34 GMT

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;