SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

e .

f .

;

run;

proc sql;

title 'One and Two Joined';

select one.a 'One', one.b, two.a 'Two', two.b

from one, two

where one.b=two.b;

/*-------------------------------------------------------------------

Output 3.8 Results of Adding IS NOT MISSING to Joining Tables That

Contain Null Values

Note: This example uses the same data sets as in Output 3.7.

-------------------------------------------------------------------*/

proc sql;

select one.a 'One', one.b, two.a 'Two', two.b

from one, two

where one.b=two.b and

one.b is not missing;

/*-------------------------------------------------------------------

Output 3.9 Selecting Capital City Coordinates (incorrect output)

-------------------------------------------------------------------*/

proc sql;

title ...