topic Re: Summing only missing values of a certain variable in SAS Programming

Summing only missing values of a certain variable

Karina77 — Fri, 26 Jun 2015 20:02:01 GMT

Hello:

Please advise. I need to create a new variable "Missing" that only contains the sum of the missing values. Thank you

data psych;

input ID $3. Ques1-Ques10 Score1-Score5;

ARRAY new (10)RQues1-RQues10;

ARRAY old (10) Ques1-Ques10;

DO i = 1 to 10;

new :smileyinfo: = 6 - old (i);

END;

ToTQues = SUM(OF Ques1 -Ques10);

datalines;

001 1 3 2 4 5 4 3 4 5 4 90 88 92 95 90

002 3 3 . . 3 4 5 5 1 . 64 64 77 72 71

003 . . . . 5 5 4 4 3 3 68 69 80 75 70

004 5 3 4 5 . 5 4 3 3 . 88 77 66 77 67

005 5 4 3 2 1 1 2 3 4 5 92 93 94 95 99

006 4 5 1 3 2 5 3 1 1 1 55 65 71 85 91

007 3 2 2 1 5 4 5 3 2 2 60 70 88 79 82

008 2 1 1 5 5 4 4 2 1 3 65 87 90 60 55

009 1 1 1 3 2 2 3 5 4 4 71 81 91 77 88

010 2 3 3 4 1 5 2 2 3 1 64 69 61 70 70

;

proc print data = psych;

run;

Re: Summing only missing values of a certain variable

LinusH — Sun, 28 Jun 2015 19:17:06 GMT

Sum of missing is...missing....?

Please give some sample desired output data.

Re: Summing only missing values of a certain variable

KachiM — Sun, 28 Jun 2015 20:55:11 GMT

Do you want the count of missing values of Ques1 - Ques10? If so, then try this:

data psych;

input ID $3. Ques1-Ques10 Score1-Score5;

Tot_Miss = nmiss(of Ques:);

datalines;

001 1 3 2 4 5 4 3 4 5 4 90 88 92 95 90

002 3 3 . . 3 4 5 5 1 . 64 64 77 72 71

003 . . . . 5 5 4 4 3 3 68 69 80 75 70

004 5 3 4 5 . 5 4 3 3 . 88 77 66 77 67

005 5 4 3 2 1 1 2 3 4 5 92 93 94 95 99

006 4 5 1 3 2 5 3 1 1 1 55 65 71 85 91

007 3 2 2 1 5 4 5 3 2 2 60 70 88 79 82

008 2 1 1 5 5 4 4 2 1 3 65 87 90 60 55

009 1 1 1 3 2 2 3 5 4 4 71 81 91 77 88

010 2 3 3 4 1 5 2 2 3 1 64 69 61 70 70

;

run;

Re: Summing only missing values of a certain variable

Karina77 — Sun, 28 Jun 2015 21:33:45 GMT

that worked! thank you