Hi, I want to do a conditional merge using proc SQL that: Searches dataset two within/grouped by ‘ID’ for treatment codes 1 or 2. Something like:By distinct id, IF treatment_code in (1,2) then in_treatment = “Yes” else “No”. I want to merge datasets one and two, keeping all values from one and adding the new variable in_treatment that is calculated from two. data one; input id name $; datalines; 1 Tim 2 Tom 3 Beth 4 Harry run; data two; input id treatment_code; datalines; 1 1 1 2 2 1 2 4 2 9 3 11 4 2 run; data want; id name In_teatment 1 Tim "Yes" 2 Tom``"Yes" 3 Beth "No" 4 Harry "Yes" ; Thanks! 🙂
... View more