topic Re: How to create a table to count non missing values for hundreds of columns? in SAS Programming

How to create a table to count non missing values for hundreds of columns?

huhuhu — Thu, 09 Nov 2017 17:24:36 GMT

Dear all,

I would like to create a table to count the number of non missing values for hundred of columns. My data looks like this:

col1 col2 col3 col4 ... col888

1 10 . 5 ... 23

56 . 4 23 ... 44

. . . 10 ... 23

1 10 . 5 ... .

The table I would like to have is like this:

col1 3

col2 2

col3 1

col4 4

...

col888 3

Really appreciate any help and advice.

Thank you so much!!

Reeza — Thu, 09 Nov 2017 17:28:01 GMT

Run a PROC MEANS with the NMISS output if they're all numeric.

If you need an example, see example 2 and 10 in the PROC MEANS documentation.

If you still have issues post your code and log.

Astounding — Thu, 09 Nov 2017 17:37:36 GMT

It is as simple as @Reeza described. However, you will need to get N (not NMISS) to count nonmissing values. A simple report:

proc means data=have n;

var _numeric_;

run;

Getting an output data set instead of a report is just slightly different:

proc means data=have noprint;

var _numeric_;

output out=want (drop=_type_ _freq_) n=;

run;

However, the shape of that data set might need to be adjusted (depends on how you intend to use it).

huhuhu — Thu, 09 Nov 2017 18:22:18 GMT

Thank you!

huhuhu — Thu, 09 Nov 2017 18:22:29 GMT

Thank you a lot!