DATA Step, Macro, Functions and more

dealing with data

Accepted Solution Solved
Reply
Contributor s_m
Contributor
Posts: 22
Accepted Solution

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. 


sas_doubt1.png

Accepted Solutions
Solution
‎04-08-2017 05:54 AM
Regular Contributor
Posts: 178

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

View solution in original post


All Replies
Solution
‎04-08-2017 05:54 AM
Regular Contributor
Posts: 178

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 s_m
Contributor
Posts: 22

Re: dealing with data

Thanks for your help.
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 117 views
  • 1 like
  • 2 in conversation