How to generate percentage values in a 3 way frequency table?

[Shashank Shukla]

Dear Friends;

I am trying to work out my descriptive tables where I have to obtain a table of corresponding values between 2 variables, further segregated by a third variable. The command
<table Dum_Gender LC4, by(LC3) contents(freq) column> is working fine, but I want the corresponding percentage values also.
Dum_Gender is a dummy for Females=1 and Males=0
LC4 is a categorical variable with 3 values of Never, Sometimes, Often
LC3 is also a categorical variable with 2 values of Faced Violence and Not faced violence
Image attached for reference

Kindly advice.
Regards

[Maarten Buis]

tabulate Dum_Gender LC4, by(LC3) row

[Shashank Shukla]

Many thanks for your reply. I tried the above command but it threw up an error as stated below:
. tabulate Dum_Gender LC4, by(LC3) row
option by() not allowed
r(198);

I then tried <table Dum_Gender LC4, by(LC3) row> and it did not give percentages either. Screenshot attached

[Shashank Shukla]

I figured this out myself from the STATA manual. Posting it here for the benefit of colleagues who might face a similar issue. The key is to use <by> command in conjunction with <tabulate> command to prepare n way tables with frequency and percentage
by LC3: tabulate Trust_Police LC4, chi column