topic Re: How to count the number of variables with values in SAS Programming

How to count the number of variables with values

lmtamina — Wed, 09 Sep 2020 15:30:03 GMT

Hi there,

I would like to ask for assistance on how to write the SAS code to count number of variables with values.

I have the following variables in my table : Diagnosis1,Diagnosis2, Diagnosis3, Diagnosis4, Diagnosis5

And I would like to count the number of variables only if they have a value.

For example, if I only have values for Diagnosis1 , Diagnosis2 and Diagnosis3 , and there are NO values for Diagnosis4 and Diagnosis5 , my diagnosis count will be = 3 .

Greatly appreciate any assistance.

Thank you in advance.

Re: How to count the number of variables with values

PaigeMiller — Wed, 09 Sep 2020 15:42:33 GMT

In a SAS data step, use the N() function, something like this will work:

data two;
    set one; 
    count=n(of diagnosis1-diagnosis5);
run;

Re: How to count the number of variables with values

ballardw — Wed, 09 Sep 2020 15:35:49 GMT

Are your variables numeric or character?

If the values are numeric you can use the N function

diagnosis_count = n (diagnosis1,diagnosis2,diagnosis3,diagnosis4,diagnosis5);

Re: How to count the number of variables with values

PaigeMiller — Wed, 09 Sep 2020 15:51:59 GMT

If the values are character, you can use the CMISS() Function to count the missings and then the number of non-missing is

count = 5 - cmiss(of diagnosis1-diagnosis5);

Re: How to count the number of variables with values

lmtamina — Wed, 09 Sep 2020 16:18:49 GMT

Thank you all! The variable type is character so I used the CMISS option to count. Appreciate all your expertise.