As a variation of "Producing Rows from the First Query or the Second Query" below code should do:
proc sql; create table want as
select * from Company where Deptid not in (select Deptid from Dept) outer union corr select * from Dept where Deptid not in (select Deptid from Company) ; quit;
⏰
Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.
Plus, pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.