Hi, I'm using a fairly simple code to make a cross-tabulation table with grades 1 to 5 (pre-adjustment grades) down the side against grades 1 to 5 and 'Exclusions' (post-adjustment grades) across the top as follows:
The thing is, one of the columns on my table is called 'Exclusions' and I would like these figures excluded from the Total (or 'all') at the end of the table.
Does anyone know of any way of doing this?
You'll have to do your tweaked sum before hand I am afraid, as in:
[pre]proc summary data=sashelp.class nway noprint;
if AGE <14 then TOT+_FREQ_;
label TOT= 'Total for <14';
proc tabulate data=TAB;
var TOT _FREQ_;
table (AGE all='Total')*_FREQ_=''*sum=''*f=2.0 TOT*max='';