topic Re: Proc Tabulate: Exclude Column from Total in SAS Procedures

Proc Tabulate: Exclude Column from Total

deleted_user — Wed, 03 Jun 2009 09:07:39 GMT

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:

proc tabulate data=work.current;
class before_adjustment after_adjustment /order=data;
classlev before_adjustment after_adjustment /s=[background=white];
table Before_Adjustment=' ' all={ label='Total' s=[background=vligb]},
N=' '*(After_Adjustment='Period 2 - Current' all={ label='Total' s=background=vligb]})*F=comma12./RTS=10.
box='Period 1 Previous' misstext=' ';
run;

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?

Any help greatly appreciated!

Re: Proc Tabulate: Exclude Column from Total

ChrisNZ — Thu, 04 Jun 2009 02:41:27 GMT

You'll have to do your tweaked sum before hand I am afraid, as in:
[pre]proc summary data=sashelp.class nway noprint;
class AGE;
output out=CLASS;
run;
data TAB;
set CLASS;
if AGE <14 then TOT+_FREQ_;
label TOT= 'Total for <14';
run;
proc tabulate data=TAB;
var TOT _FREQ_;
class AGE;
table (AGE all='Total')*_FREQ_=''*sum=''*f=2.0 TOT*max='';
run;

Re: Proc Tabulate: Exclude Column from Total

deleted_user — Thu, 04 Jun 2009 11:08:24 GMT

Ok, thanks for your help!