Hi, Let's say my data set is set up like this: study_id structure_id 1 BLADDER 2 . 3 BOWEL 4 BOWEL_SMALL 5 GTV 6 GTV_small I want to delete records where structure_id contains "BOWEL" or "GTV". I tried using this code: data dvh_edited;
set dvh;
found=indexc(structure_id, "BOWEL", "GTV");
if found ^=0 then delete;
run; But with that code it is looking for any letter in "BOWEL" or "GTV" so it's tagging many records. I'm not that familiar with PROC SQL so I'd prefer to do this in a data step if it's fairly simple. Thanks!
... View more
