New SAS user, still figuring it out. I have an Excel sheet that I need to simplify in SAS. This is what I'm trying to do: ID Contact 1 Contact 2 Contact 3 1 Bob Sarah Elizabeth 2 John Sarah Jean 3 Peter Sarah Elizabeth 4 Jean Peter John 5 Peter Jean Elizabeth Now, I need to remove all rows that have "Bob" in any of the 3 contact columns AND remove all rows that have Elizabeth in any of the 3 contact columns. The final table would look like this: ID Contact 1 Contact 2 Contact 3 2 John Sarah Jean 4 Jean Peter John This is what I have so far, but it does not work to use multiple WHERE statements for some reason. proc print data = veap
WHERE contact 1 ~= 'Bob' or contact 2 ~= bob or contact 3 ~= Bob;
WHERE contact 1 ~= Elizabeth or contact 2 ~= Elizabeth or contact 3 ~= Elizabeth;
RUN;
... View more