In reply to Peter Burke.

Peter,
The Y value is missing in the fifth observation because of how the SET statement behaves when reading multiple data sets with one SET statement. The variables in the program data vector are set to missing when SAS begins reading observations from the second data set. Here's the link to our documentation on combining data sets with one SET statement. Look at "Execution - Step 2" section in particular.