冒死回复
假设作业3和作业2的数据集名分别为employee3和employee2.
proc sort data=employees3 out=out3;
        by lname fname;
proc sort data=employees2 out=out2;
        by lname fname;
data total;       
        set out3;
        by lname  fname;
        retain total 0;
        if first.fname then total=sales;
        else total+sales;
        if last.fname;
data new;
        merge total out2;
        by lname fname;
        if total ne .;
        keep lname fname job total;
ods html body='d:\new.html';
proc report data=new nowindows;
        column lname fname job total;
run;
ods html close;

Homework #3

7# hopewell 我基本上也快做出来了，不过现在有个问题，就是如何对DATA 步骤或者是PROC REPORT进行FORMAT, 比如将'SR2'  format成  'Sales Rep2'，我用了proc format，但好像对最后的report结果没影响，下面是我的程序，求改进

proc sort data=employees1;
by lname;
run;
proc sort data=employees2;
by lname;
run;
data salessum(keep=lname fname job total);
   merge employees1 employees2;
   by lname;
   if first.lname then total=0;
   total+sales;
   if last.lname then output;
run;
proc report data=salessum headline headskip split= '*' nowd;
define lname / 'Last Name' width=10;
define fname / 'First Name' width=11;
define job / 'Position' width=12;
define total / format=dollar10. width=20;
run;