Help using Base SAS procedures

help using except operator

Reply
Contributor
Posts: 43

help using except operator

Hi All,
I will be very grateful, if any one can help me.
i am trying to output dataset test: variables that are in table A not in table B
here 2 situations
1. all variable ids are same in table A and table B
2. all variable ids in table A are not equal to table B ( i know we can perform the filtering only on the same variable ids)
here is my code

proc sql;
create table test1 as select * from TABLE A as t1
except
select * from table B as t2,
on t1.lastname=t2.lastname and t1.dob=t2.dob;
quit;

I am unable to find where am going wrong
Valued Guide
Posts: 2,175

Re: help using except operator

maybe you have columns in different orders. maybe something else.
Reading the manual on line helps select the relevant section "set operators", just by searching from this page for "sql except operator" in "product documentation".
I found "corresponding". It also shows that you don't use the "ON " syntax of a join.
Have a look at the examples yourself.
And next time, please post the ERROR: messages.

good luck
PeterC
Ask a Question
Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation