proc sql; select lastname, firstname from sasuser.staffmaster where 'NA'= (select jobcategory from sasuser.supervisors where staffmaster.empid = supervisors.empid);
Condition
|
Is true if...
|
---|---|
EXISTS
|
the subquery returns
at least one row
|
NOT EXISTS
|
the subquery returns
no data
|
proc sql;
select lastname, firstname
from sasuser.flightattendants
where not exists
(select *
from sasuser.flightschedule
where flightattendants.empid=
flightschedule.empid);