Solved
Contributor
Posts: 22

# dealing with data

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.

Accepted Solutions
Solution
‎04-08-2017 05:54 AM
Valued Guide
Posts: 593

## Re: dealing with data

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#p0vl2htnkjk...

All Replies
Solution
‎04-08-2017 05:54 AM
Valued Guide
Posts: 593

## Re: dealing with data

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#p0vl2htnkjk...

Contributor
Posts: 22