- data dataset;
- input var1 var2 var3 var4 var5 var6 var7 var8;
- cards;
- 1 2 3 4 5 6 7 8
- ;run;
- proc sql noprint;
- create table output as select Var3 , Var7 ,sum(var5,var6,var7) as Var9 from Dataset;
- quit;
- proc export data=output outfile="c:\output.xls" DBMS=excel replace;
- run;