If your data contains special missing values, you can check for either an ordinary or special missing value with a statement that is similar to the following: In each case, SAS checks whether the ...

If one of the tables contains records that are orphaned—for which there is no corresponding record with a matching value in the other table—those records are ignored.