topic Re: number of missing responses for each observation in SAS Data Management

number of missing responses for each observation

code_blooded — Fri, 01 Nov 2019 19:10:19 GMT

Hi!

I am looking to determine the number of missing values for each observation (rows) in my dataset which has both numeric and character variables. it is a fairly large dataset >500 variables and has a mix of both character and numeric variables. I tried using cmiss but it said that the variables had to be either all character or all numeric.

Any insights??

Re: number of missing responses for each observation

PaigeMiller — Fri, 01 Nov 2019 19:17:27 GMT

number_missing = cmiss(of _character_) + nmiss(of _numeric_);

Re: number of missing responses for each observation

Patrick — Sat, 02 Nov 2019 04:52:59 GMT

@code_blooded

It works for me. Before investigating your code may be execute below and verify that this also works in your environment and for your SAS version.

data test;
  length ca cb $1 na nb 8;
  call missing(of _all_);
  na=1;
  n_missing=cmiss(ca,cb,na,nb);
  output;
  stop;
run;
proc print;
run;

Re: number of missing responses for each observation

code_blooded — Mon, 04 Nov 2019 16:26:22 GMT

Thanks Paige. This worked however I am getting one extra count for the missing values. ANy idea what might have cause this?

Below is the code that I have been using:

data miss;
set test;
nmiss = cmiss(of _character_) + nmiss(of _numeric_);
run;

Thanks for the help!