proc sql;
   connect to remote(server=sdcmvs.prx6xhsrv);
   select *
   from connection to remote
      (select p.idnum   label='ID Number'
              p.jobcode label='Job Code'
              s.city    label='City'
       from rmtshr.staff s,
            rmtshr.payroll p
       where s.idnum=p.idnum
       orderby jobcode);