Summing only missing values of a certain variable

Reply
Occasional Contributor
Posts: 12

Summing only missing values of a certain variable

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;

Super User
Posts: 5,437

Re: Summing only missing values of a certain variable

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

Please give some sample desired output data.

Data never sleeps
Super Contributor
Posts: 298

Re: Summing only missing values of a certain variable

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 QuesSmiley Happy;

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;

Occasional Contributor
Posts: 12

Re: Summing only missing values of a certain variable

that worked!  thank you

Ask a Question
Discussion stats
  • 3 replies
  • 176 views
  • 3 likes
  • 3 in conversation