Calculating Avearge values

[debdippal]

Suppose we have the values for each of the 3 variables eg. Score_assignment, Score_quiz, Score_forum for a set of students. Now I want to get the average value for each of the student.  But for some students values of one or more variables are missing. Then we will calculate the average by using the following formula:

1. Ex.

Student No.	Score_assignment	Score_quiz	Score_forum	Average
1	10	15	45	(10+15+45)/3
2		14	20	(14+20)/2
3	41			41/1

Please write down a sas code such that I can calculate the average value using the above logic.

[vxhong17 · Accepted solution]

Hi debdippal,

Average = mean(Score_assignment, Score_quiz, Score_forum);

[RichardinOz]

vxhong17 is correct.  Read the documentation on the mean() function and you will see that it automatically omits missing values from its calculations.

Richard

[debdippal]

Thanks