proc sql;
        select bldginfo.id,lastname,bldg,rm,ext
           from emplib.payroll,emplib.bldginfo
           where bldginfo.id=payroll.id
           order by lastname;