topic Re: count number of fields that are not null in SAS Programming

count number of fields that are not null

Ronein — Wed, 27 Mar 2019 11:27:30 GMT

Hello

I want to create a new calculated field that will count number of fields(from fields x1-x6) that are not null.

For Id=1 I expect to get value 6

For Id=2 I expect to get value 6

For Id=3 I expect to get value 4

What is the way to do it please without change the dimension of the table(without transpose)

data tbl;
input ID x1 x2 x3 x4 x5 x6 ;
cards;
1 9 8 7 6 7 8
2 7 7 6 7 7 8
3 7 7 6 7 . .
;
run;

andreas_lds — Wed, 27 Mar 2019 11:31:53 GMT

The function nmiss returns the number of missing values, you just need to subtract the total number of vars.

data want;
    set tbl;
    
    array values x1-x6;
    
    NotMissing = dim(values) - nmiss(of x1-x6);
run;

Ksharp — Wed, 27 Mar 2019 11:50:56 GMT

Why not use NotMissing = n(of x1-x6);