topic Re: Calculating Avearge values in SAS Programming

Calculating Avearge values

debdippal — Mon, 17 Jun 2013 07:21:06 GMT

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:

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.

Re: Calculating Avearge values

vxhong17 — Mon, 17 Jun 2013 08:35:23 GMT

Hi debdippal,

Average = mean(Score_assignment, Score_quiz, Score_forum);

Re: Calculating Avearge values

RichardinOz — Tue, 18 Jun 2013 11:43:58 GMT

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

Richard

Re: Calculating Avearge values

debdippal — Tue, 18 Jun 2013 11:55:11 GMT

Thanks