topic Re: How to count frequency of columns? in SAS Data Management

How to count frequency of columns?

NonSleeper — Mon, 10 Nov 2014 16:58:16 GMT

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 — Mon, 10 Nov 2014 17:14:11 GMT

data want;

set temp;

count=0;

array v var:;

do over v;

if v ne ' ' then count+1;

end;

run;

KachiM — Mon, 10 Nov 2014 17:19:03 GMT

Will this help you?

data want;

set temp;

array k

var1 - var3;

count = dim(k) - cmiss(of k

);

run;

Reeza — Mon, 10 Nov 2014 18:34:16 GMT

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

data want;

set temp;

array k

var1 - var3;

count = n(of k

);

run;