Proc Transpose, column percentages 100% for all variables under "ALL"

[Sas_Geek]

Hi,

I'm running following code:

proc tabulate;

class year patient_sex_text;

tables (all year)*(all patient_sex_text), n pctn<all patient_sex_text>;

run;

and following is the output I'm getting:

		N	PctN
All	All	2290	100.00
	Patient_Sex_Text	961	100.00
	Female
	Male	1329	100.00
year		1644	100.00
05/10-04/11	All
	Patient_Sex_Text	675	41.06
	Female
	Male	969	58.94
05/11-04/12	All	646	100.00
	Patient_Sex_Text	286	44.27
	Female
	Male	360	55.73

How can I change the column percent of the yellow highlighted cells from 100 to 41.97 and 58.03?

Thanks in advance!