data mergdata.emppay;
        merge reps(rename=(office=officenumber) in=inreps)
              empinfo.sales(in=insales) 
              empinfo.bonuses(in=inbonus);
        by id;
        
     run;