topic Re: PROC MEANS in SAS Procedures

PROC MEANS

Quodly — Mon, 29 Jul 2019 19:29:48 GMT

Is there any difference between the _freq_ variable and the N output statistic?

Re: PROC MEANS

Reeza — Mon, 29 Jul 2019 19:45:35 GMT

@Quodly wrote:

Is there any difference between the _freq_ variable and the N output statistic?

Yes, if you have missing values.

N is the count of non missing, frequency is the count of all values.

NMISS+N = _FREQ_.

data class;
set sashelp.class;
if age in (13, 14, 15) then call missing(weight);
run;

proc means data=class;
class sex;
var weight;
output out=want sum= mean= N= NMISS=/ autoname;
run;

Re: PROC MEANS

PGStats — Mon, 29 Jul 2019 19:56:05 GMT

There is a difference when missing values are present in your VAR variable or when you specify a FREQ variable. A simple example:

data test;
input f x;
datalines;
1   1
1   .
5   .
.   2
;

proc means data=test;
var x;
freq f;
output out=want n=n;
run;

proc print data=want; run;

                            Obs    _TYPE_    _FREQ_    n

                             1        0         7      1