Trouble with Proc Tabulate

[GreyJoy]

I have attached the sample code that I am using along with a sample dataset and an excel file of what I am trying to achieve. 

I have a data set with variable that are not mutually exclusive but I want to layer them into a table as percentages of the over all count. 

                       TREATMENT

                               A                           B                             C

Total People  =  10   100%               8    100%               13  100%

White            =  3       30%               5     62,5%               3     23%

Fast               =  7      70%               0        0%                 12   92%

Ugly               =  5      50%               5     62.5%               7     54%

I can not get this to work right. Help me Obi Wan, you are my only hope. 

[ballardw · Accepted solution]

Your example data has no value of UGLY or Fast and your code does not show any variable labeled as such so your example table is moderately useless.

I am not going to open Excel files of unknown origin.

You would probably do yourself a favor by having your VAR variables have a value other than 1, such as 0 for the "doesn't have the condition".

I suspect that you want PCTSUM in some form possibly:

proc tabulate data=work.death_table 
         format=7.0 style=[font=("Arial",9pt) ] missing ;
	class partial_blind ;

	var trt_x_dth 
		trt_x_wdr 
		trt_x_pn 
		trt_x_pc
		trt_x_oth
		total;
	table total (trt_x_dth trt_x_wdr 
          trt_x_pn trt_x_pc trt_x_oth)/*(N COLPCTN*F=pctfmt.)*/  , 

				(partial_blind)*(N PCTsum<total>*F=pctfmt.) 
            ( all="Total")*(N PCTsum<total>*F=pctfmt.)
  ;
	label
      trt_x_dth="Deaths" 
      trt_x_wdr="Withdrawl" 
      trt_x_pn="PN" 
      trt_x_pc="PC" 
      trt_x_oth="OTH"
      partial_blind='Treatment Group'
   ;
run;

I moved the labels for the variables out of the table statement so it would be easier to read.

The the Pctsum<total> uses the sum of the variable Total for a denominator in the percentage calculation. DO not use any of the Rowpctsum, Colpctsum, Pagepctsum or the similar Pctn functions this way or you may create a serious fault that will crash SAS.