*Slide 3;

data google;
input name $ residence $16.;
datalines;
John Columbia, SC
Laura Cambridge, MA
Melissa Los Angeles, CA
Michael Orlando, FL
Joseph London, England
Melissa Los Angeles, CA
Mark Napierville, IL
John Washington, DC
;
run;

proc sql;
select * from google;
quit;

data bing;
input name $ city $17.;
datalines;
Mark Napierville, IL
Joseph London, England
Michael Orlando, FL
Melissa Los Angeles, CA
VG Yerevan, Armenia
;
run;

proc sql;
select * from bing;
quit;

*Slide 8;
proc sql;
select * from google
except
select * from bing;
quit;

*Slide 10;
proc sql;
select * from google
except all
select * from bing;
quit;

*Slide 13;
proc sql;
select * from google
except corr
select * from bing;
quit;

*Slide 15;
proc sql;
select * from google
except corr all
select * from bing;
quit;

*Slide 16;
proc sql;
select * from google
intersect
select * from bing; 
quit;

*Slide 19;
proc sql;
select * from google
intersect all
select * from bing; 
quit;

*Slide 21;
proc sql;
select * from google
intersect corr
select * from bing; 
quit;

*Slide 22;
proc sql;
select * from google
intersect all corr
select * from bing; 
quit;

*Slide 23;
proc sql;
select * from google
union
select * from bing; 
quit;

*Slide 26;
proc sql;
select * from google
union all
select * from bing; 
quit;

*Slide 27;
proc sql;
select * from google
union corr
select * from bing; 
quit;

*Slide 29;
proc sql;
select * from google
union all corr
select * from bing; 
quit;

*Slide 30;
proc sql;
select * from google
outer union
select * from bing; 
quit;

*Slide 31;
proc sql;
select * from google
outer union corr
select * from bing; 
quit;