topic Re: dealing with data in SAS Programming

dealing with data

s_m — Sat, 08 Apr 2017 08:47:29 GMT

data scores;
infile '/folders/myshortcuts/s2/scores.txt';
input gender$1. score1 score2 score3 score4;
avg=(score1+score2+score3+score4)/4;
run;

In scores.text I have given one missing value for score2 in one obsevation.For the same obsevation Value of avg is also coming as missing.Please refer the screenshot attached.

Please tell me why avg is not coming for this obsevation.

Re: dealing with data

ChrisBrooks — Sat, 08 Apr 2017 09:16:01 GMT

The result of any mathematical operation on a missing value results in an answer of missing hence your result.

If you want the average of the non-missing values use the mean function detailed here http://support.sas.com/documentation/cdl/en/lefunctionsref/69762/HTML/default/viewer.htm#p0vl2htnkjkvejn1lsx2004n6dqp.htm

Re: dealing with data

s_m — Sat, 08 Apr 2017 09:55:49 GMT

Thanks for your help.