Summarize by time for panel data

[Manuel Krain]

Der Statalist users,

I am trying to generate summary statistics(mean, standard deviation and quintiles) for my panel variables(e.g. size, number of holdings) for each time variable(quarter) and to average them over time to get one summary table. However, i am not able to find a solution. -xtsum- is not helping because only the standard deviation is reported.

Thank you in advance.

[Phil Bromiley]

You can use bysort quarter: su x
Which will give you a pile of output. I would think that this is doable with the table command. Alternatively, you could collapse the data by quarter.