BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Quodly
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

@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;

View solution in original post

2 REPLIES 2
Reeza
Super User

@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;
PGStats
Opal | Level 21

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
PG

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 946 views
  • 1 like
  • 3 in conversation