means from multiple observations of multiple variables

[Felix Stips]

Dear statalists,

say I have a data structure like this (see in the comment below).

How can I then get the mean of all prizes without having to take means of means?

Thank you!

[Felix Stips]

prize 1	prize 2	prize 3
3	4	5
6	2	2

[Carlo Lazzaro]

Felix:
Do you mean something along the following lines?

. stack prize_1 prize_2 prize_3 , into( prize_tot )
Warning:  data in memory will be lost.
         Press any key to continue, Ctrl-Break to abort.

. tabstat prize_tot, stat(count mean sd p50 min max)

    variable |         N      mean        sd       p50       min       max
-------------+------------------------------------------------------------
   prize_tot |         6  3.666667  1.632993       3.5         2         6
--------------------------------------------------------------------------

.

[Felix Stips]

Yes, the stack does the trick, thank you. Wow, I didn't expect that a command would exist for this case.

[Carlo Lazzaro]

Felix:
having a sort of mental dashboard that helps you to retrieve the Stata commands you need (even though you do not use them regularly) is really rewarding and pays back many times more the hours you devoted to study Stata and its several features.

[Phil Bromiley]

Stata has some nice "cheat sheets" available with Stata commands. Look at
https://www.stata.com/links/resource...g-stata/#cheat