@bemariec wrote: Sorry! yess! Missing values are excluded Except for n ans nmiss, where missing values are included
I think you need to say something about which specific variables you are discussing as CLASS variables with missing values are excluded:
data junk;
input x;
datalines;
.
1
1
1
.
3
3
3
3
2
;
run;
proc tabulate data=junk;
class x;
table x all,n;
run;
10 obs in, 8 reported on.
Tabulate by default will exclude all rows with ANY of the class variables missing.
So when you look at individual variables such as with proc means or freq the class variables values will ALL show.
data junk;
input x y;
datalines;
. 1
1 2
1 3
1 .
. 5
3 1
3 1
3 .
3 1
2 1
;
run;
proc tabulate data=junk;
class x Y;
table x *y,n;
run;
proc means data=junk n;
var x y;
run;
Tabulate: 6 records, Means 8 values for each of x and y.
So you might want to consider providing some example data and what the desired result is.
... View more