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!!
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.
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.
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).
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.