Hi Reeza,
Thank you so much for your help.
** trying to compare Table A with Table B to determine contents in Table A changed/missing in Table B and produce output for additional review**
This is the code I applied which you suggested.
proc sql;
create table missing as
select * from TABLEA
where PATIENTID LOCATION DATE PROC OUTCOME
not in (select distinct PATIENTID LOCATION DATE PROC OUTCOME from TABLEB);
quit;
Syntax error after PatientID
ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, (, *, **, +, -, '.', /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING, IN,
INTERSECT, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ORDER, OUTER, UNION, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
... View more