topic Re: Count different kinds of missing values for numerical variable in SAS Programming

Count different kinds of missing values for numerical variable

riccardo88 — Wed, 06 Jan 2021 09:31:33 GMT

Hello everybody,

I have a dataset of this kind:

data have;                    
input var;
datalines; 
34
54
.a
.b
65
.b
;

As you can see I have different kinds of missing values identified with "A" and "B".

I would like to know how many A and B missing values are there:

e.g. A: 1; B: 2

Does anybody know how?

Thank you very much!

SAS Version: 9.4

Re: Count different kinds of missing values for numerical variable

PeterClemmensen — Wed, 06 Jan 2021 09:36:36 GMT

You can use Proc Summary with the Missing Option like this. The _FREQ_ Variables gives you the answer.

data have;                    
input var;
datalines; 
34
54
.a
.b
65
.b
; 

proc summary data = have missing nway;
   class var;
   output out=want;
run;

Result:

Obs  var  _TYPE_  _FREQ_ 
1    A    1       1 
2    B    1       2 
3    34   1       1 
4    54   1       1 
5    65   1       1

Re: Count different kinds of missing values for numerical variable

FreelanceReinh — Wed, 06 Jan 2021 09:36:28 GMT

Hello @riccardo88,

Or use PROC FREQ:

proc freq data=have;
tables var / missing;
run;

You can restrict the counts to missing values by adding a WHERE statement to this step, e.g.

where missing(var);