PROC TABULATE: totals across multiple class variables

[mkeintz]

The problem is that what you want is to double count in the ALL row (actually "up to ten" count), for which tabulate does not provide a mechanism.

I suggest a data set VIEW with a new variable, to be included in the proc tabulate.

data vneed / view=vneed;
  set have (keep=columnvar rowvar1-rowvar10);
  row_count=n(of rowvar:);
run;

proc tabulate data=vneed;
  class columnvar rowvar1-rowvar2;
  var row_count;
  table  rowvar1-rowvar2
         row_count*sum='Col Total'
         ,columnvar;
run;

[Curt]

Hi mkeintz,

thanks for you suggestion.

Unfortunately, the code doesn't seem to work: the row_count always displays a zero and the table  shows only one value of each variable.