Hi all! I'm wondering if it is possible to tell SAS to include more than one WHERE clause in a PROC SQL, and if so, how? Here is what I attempted to do. I have 2 datasets, NOC_TRY4 and NOC_75. NOC_75 is a list of OCCGROUPS and CODES that I want to be included in the original dataset NOC_TRY4 - that is, any CODE within an OCCGROUP that is not included in the list NOC_75 should be deleted. PROCSQL; CREATETABLE GOODDATA AS SELECT * FROM NOC_TRY4, NOC_75 WHERE NOC_75.OCCGROUP=NOC_TRY4.OCCGROUP WHERE NOC_75.CODE=NOC_TRY4.CODE; QUIT; SAS returns this error in the logs: 1413 PROC SQL; 1414 CREATE TABLE NICETRY AS 1415 SELECT * FROM NOC_TRY4, NOC_75 1416 WHERE NOC_75.OCCGROUP=NOC_TRY4.OCCGROUP 1417 WHERE NOC_75.CODE=NOC_TRY4.CODE; ----- 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING, INTERSECT, LE, LET, LT, LTT, NE, NET, NOT, OR, ORDER, OUTER, UNION, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored. 1418 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Any help or tips would be greatly appreciated! Thank you! (Please see my response to Reeza below for an update of the problem I keep running into)
... View more