Suppose I have a dataset looks like the following: ID . age MED1 MED2 MED3 001 . 1 1055 7832 3435 202 . 0 1051 3423 3455 204 . 3 5040 3423 . 3444 213 . 4 9999 3432 . 4546 Each patient has three prescriptions and each has a code comes with it. I want to see if patients age less than 5 have prescription MED1-MED3 in code (7832, 3435, 1051). I used proc sql the following but it gave me the same dataset. PROC SQL;
CREATE TABLE WANT AS
SELECT *
FROM MEDS
WHERE MED1 OR MED2 OR MED3 IN (7832, 3455, 1051) AND AGE <= 5;
QUIT; How can I correct this? Thanks.
... View more