Hello,

I am new to Stata and I have, for a few days by now, been stuck with the following problem: I am trying to create a table that lists summary statistics (mean, sd, median, freq) for multiple continuous variables where the summary statistics are calculated by Groups. In the table below I tried to illustrade what I am trying to do:
Weight Foot S
ize
 BMI
Children mean: 40, median: 30, sd: 5, freq: 1000
mean: 15, median: 12, sd: 3, freq: 1000
 ...
Young Adults
mean: 80, median: 65, sd: 15, freq: 700
 ... ...
Elderly
mean: 60, median:55, sd: 5, freq: 500
 ... ...
I have been searching the Internet for hours now, but all I found in the forums were tables where the "top variables" of the table were not individual variables, but a categorical one, which is not the case for me. I have the categories on the left stored in a categorical variable but the top ones are independet variables.


FYI: As soon as we have solved this problem I actually do have another similar question: I need a second table for which the top variables are not continous but all categorical (e.g. imagine instead of a foot size in cm, we now have a categorical variable storing the foot size as S/M/L/XL/XXL and some other variables similar to this example). Obviously, I cannot do summary statistics here, but I would like to have the table Display the most common variant & the according percentage.

I hope I was able to illustrade my problem well, and I am looking forward to your suggestions! Thanks in advance!