Count number of responses across observations

monsterpie — Sun, 21 Mar 2021 18:52:10 GMT

Hi all,

I'm trying create a new variable that counts the number of responses across 5 variables within the same row.

example dataset:

Col1 Col2 Col3 Col4 Col5 Count

Dew Coke . 7up Juice 4

Lays Pepsi Aero Crush Sprite 5

The SAS code I've tried so far is but this code just gives a missing value in the count column:

data brand;
count=sum(of col1--col5);
run;

Thanks in advance for any help!

Re: Count number of responses across observations

PeterClemmensen — Sun, 21 Mar 2021 18:59:42 GMT

Try this

data have;
input (Col1-Col5)(:$);
datalines;
Dew  Coke  .    7up   Juice  
Lays Pepsi Aero Crush Sprite 
;

data want;
   set have;
   count = 5 - cmiss(of Col1-Col5);
run;

topic Re: Count number of responses across observations in New SAS User

Count number of responses across observations

Re: Count number of responses across observations