Hello SAS Experts, I am trying to get all records from dataset have which are not in dataset have1: data have; a='A';output; a='B';output; a='C';output; run; data have1; b='E';output; run; proc sql; create table want as select * from have where a not in (select a from have1); quit; I am wondering why there is no error message with "ERROR: Column a could not be found in the table/view identified with the correlation name have1." If i change my code like this,i get the error message: proc sql; create table want as select * from have x where a not in (select y.a from have1 y); quit; Thank you for helping,
... View more