Hi, Here are two methods: METHOD 1: Using a where clause in both directions combined by a union all. Method 1: PROC SQL;
CREATE TABLE WANT AS
SELECT UNIQUE NEW_ID FROM HAVE_1
WHERE NEW_ID NOT IN (SELECT UNIQUE NEW_ID FROM HAVE_2) UNION ALL SELECT UNIQUE NEW_ID FROM HAVE_2 WHERE NEW_ID NOT IN (SELECT UNIQUE NEW_ID FROM HAVE_2)
;QUIT; Method 2: Leveraging subqueries to create a union all NEW_ID's. Both tables have only 1 column, so it isn't ambiguous. The outermost query deduplicates. METHOD 2:
PROC SQL;
CREATE TABLE WANT AS
SELECT UNIQUE *
FROM (SELECT * FROM (SELECT UNIQUE NEW_ID FROM HAVE_1)
UNION ALL
SELECT * FROM (SELECT UNIQUE NEW_ID FROM HAVE_1)
)
;QUIT;
... View more
