Is there any difference between the _freq_ variable and the N output statistic?
@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;
@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;
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.