topic Re: How do I count the number of columns with valid values per row? in SAS Data Science

How do I count the number of columns with valid values per row?

RoseRahman — Mon, 10 Aug 2015 19:38:49 GMT

ID	ICD1	ICD2	ICD3	ICD4	ICD5
1001	808.1	201	101.9	003	922
1002		421.0	556	707.3	997
1003	787.2			308	599.8

I have 5 ICD codes in 5 columns, they are character variables. I want to be able to count how many valid values each subject has in the 5 ICD columns. So, for 1001, the result would be 5, for 1002 it will be 4 and 1003 will be 3. Or we could see it as the number of missing values in an array of variables per subject. Thank you.

Re: How do I count the number of columns with valid values per row?

ballardw — Mon, 10 Aug 2015 20:14:05 GMT

in a data step:

data want;

set have;

numvalid = n( of ICD1-icd5);

run;

The function NMISS with the same basic syntax would give the missing per record.

Re: How do I count the number of columns with valid values per row?

Steelers_In_DC — Mon, 10 Aug 2015 20:49:13 GMT

for character variables you would use the function cmiss().

For count of not missing:

data want;

set have;

valid = 5 - cmiss(of icd1-icd5);

run;

or for count of missing:

data want;

set have;

valid = cmiss(of icd1-icd5);

run;

Re: How do I count the number of columns with valid values per row?

RoseRahman — Mon, 10 Aug 2015 21:55:51 GMT

This works! Thank you! I also tried the longer method that seems to work.

array _icdvar ICD1-ICD5;

cnticd=0;

do i=1 to 5;

if missing(_icdvar(i)) = 0 then cnticd=cnticd+1;
end;

drop i;