DATA Step, Macro, Functions and more

datasets

Reply
Frequent Contributor
Posts: 75

datasets

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 ?

 

Super User
Super User
Posts: 8,289

Re: datasets

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;
Ask a Question
Discussion stats
  • 1 reply
  • 82 views
  • 0 likes
  • 2 in conversation