MEAN
Returns the arithmetic mean (average)
Argument is numeric At least one non-missing argument is required otherwise, the function returns a missing value
Syntax: – MEAN(argument<,argument,…>)
Data ds1;
x1=mean(2,.,.,6);
x2=mean(2,4,5,6);
x3=mean(x1-x2); /*x3=mean(4-4.25)=-0.25/1=-0.25*/
x4=mean(of x1-x2); /*it means x1, x2 means 4,4.25 means 8.25/2=4.125*/
x5=mean(x1,x2);
Run;
Data ds1;
x1=mean(2,.,.,6);
x2=mean(2,4,5,6);
x3=mean(2,4,5,6);
y=mean(3,3,5);
x4=mean(x1-x2);
x5=mean(of x1-x3);
x6=mean(x1,x2);
xa=mean(2,5);
x7=mean(of x:);
x8=mean(of x1–x4);
Run;
MEDIAN
Computes median values.
Syntax: – MEDIAN(value1<, value2, …>)
Data ds2;
x=median(2,4,1,3);
y=median(5,8,0,3,4);
z=median(5,.,0,.,4);
Run;
Difference between MEAN & MEDIAN
Mean will give average of numeric values
Ex:- x=mean(70,60,80,75,90)
x=70+60+80+75+90/5
x=375/5=75
In MEDIAN data will arrange from lowest to highest
in that data middle no is MEDIAN value
60,70,75,80,90
75 is mid value which is median value
Ex:- x=median(2,4,1,3);
in above example mid value is 4,1
it means 4+1=5
median value is 5/2=2.5;
MIN
Returns the smallest value
Syntax: – MIN(argument,argument,…)
Data ds3;
x1=min(7,4);
x2=min(2,.,6);
x3=min(2,-3,1,-1);
x4=min(0,4);
x6=min(of x1-x3);
x7=min(x1,x3);
Run;
MAX
Returns the largest value
Syntax:-MAX(argument,argument,…)
Data ds4;
x=max(8,3);
x1=max(2,6,.);
x2=max(2.-3,1,-1);
x3=max(3,.,-3);
x4=max(.,.,.);
x5=max(of x1-x3);
Run;
Argument is numeric. At least two arguments are required. The argument list may consist of a variable list, which is preceded by OF.
The MAX function returns a missing value (.) only if all arguments are missing.