How to count frequency of columns?

[NonSleeper]

The data looks like this:

data temp;

input ID Var1 Var2 Var3;

datalines;

001 x11 x12 x13

002 x21 .     x23

003 .      .    .  ;

I want to create a new variable (Count) which counts the frequency of valid values from Var1 to Var3, so the new data looks like:

ID   Var1 Var2  Var3  Count

001 x11   x12   x13    3

002 x21   .       x23    2

003 .       .        .       .

;

I'm not sure if the count value for ID=003 is missing value or 0, but the idea is basically the same.

[stat_sas]

data want;

set temp;

count=0;

array v var:;

do over v;

if v ne ' ' then count+1;

end;

run;

[KachiM]

Will this help you?

data want;

   set temp;

   array k

var1 - var3;

   count = dim(k) - cmiss(of k

);

run;

[Reeza]

Use the n() function, if the data is numeric not character.

data want;

   set temp;

   array k

var1 - var3;

   count = n(of k

);

run;