Aggregate functions

Generates SUM's MIN MAX STD

data ps1;
input pcode $ m1-m6;
cards;
p101 210 230 210 220 230 220
p102 210 300 250 310 180 190
p103 220 210 240 231 225 262
p104 210 220 230 180 . 160
;

data ps2;
set ps1;
t1sale=m1+m2+m3+m4+m5+m6;
t2sale=sum(m1,m2,m3,m4,m5,m6);
avgsale=round(mean(m1,m2,m3,m4,m5,m6));
maxsale=max(m1,m2,m3,m4,m5,m6);
minsale=min(m1,m2,m3,m4,m5,m6);
run;
proc print data=ps2;
run;

/*generate std mean*/
data ps3;
set ps1;
Asale=mean(of m1-m6);
Dsale=std(of m1-m6);
run;
proc print data=ps3;
run;

/*label*/
data ps3;
set ps1;
Asale=mean(of m1-m6);
Dsale=std(of m1-m6);
run;

proc print data=ps3 label;
var pcode Asale Dsale;
label pcode='product code'
Asale='average sale'
Dsale='standard deviation';
run;