Change all missing values of all variables into zeros/putting zeros in place of missing values for variables
Have you been asked how to convert missing values for all the variables into zeros..... if you are.... here is the answer for that..... In this example the I have used array to do the same. The variable list includes ID and Score1 to score6.Using simple array method we can change all the missing value for the variables score1 to score6 to 0. data old; input ID SCORE1 SCORE2 SCORE3 SCORE4 SCORE5 SCORE6; cards; 24 100 97 . 100 85 85 28 . 87 98 100 . 90 60 100 . . 100 100 100 65 100 98 100 . 90 100 70 99 97 100 100 95 100 40 97 99 98 . 100 95 190 100 . 97 100 100 90 196 100 100 . 100 100 100 210 . 85 . 90 80 95 ; run ; *Ist Method; data new; set old; array zero score1-score6; do over zero; if zero=. then zero=0 ; end ; run ; *2nd Method; data new; set old; array nums _numeric_; do over nums ; if nums=. then nums=0 ; end; run ; proc print; Title 'Missing values changed to zero using arrays and a do loop' ; run ; Output: I...