summarize variable, detail but for each year

[Anshul Anand]

Solved!

For others:

[CODE]
bysort year: sum lnhourlyw, detail
[\CODE]

Sorry, I was looking for other codes like xtsum etc.

[eric_a_booth]

One option is something like:

sysuse auto, clear

g year = mod(_n, 5)
bys year: su price, d


**but I find this more useful
tabstat price, by(year) s(min p10 p25 p50 p75 p90 max N)

[Anshul Anand]

Thank you very much! This is really more useful!

[Attaullah Shah]

asdoc (from SSC) can find normal , customized and detailed summary statistics over a grouping variable and create a nicely formatted tables in MS word. See this example

 ssc install asdoc

bysort year: asdoc tabstat lnhourlyw, stat(min p10 p25 p50 p75 p99 max N)

And using the eric_a_booth example, we get

 sysuse auto, clear
g year = mod(_n, 5)
asdoc tabstat price, by(year) stat(min p10 p25 p50 p75 p99 max N)

The output is given below.

For more options and customized statistics, you can watch this YouTube Video.

[ram singh]

Dear Dr Shah,
Thanks for the great program. Really appreciate it. A question : If I were to 1) add text to the document myfile.doc which was already created by asdoc, but this time using the microsoft word program and opening the word file on the computer, and then 2) save the file and then after that 3) again if I try to append another table to the same document using append option, then I get an error "not enough space in memory or disk". This error does not occur if were to continue to adding tables using append option from the asdoc program itself without ever editing it outside stata using asdoc command. Is this something intended: that once I modify the document myself outside stata using msword (not using asdoc) then I can no longer add tables using asdoc. (sorry I hope my language adequately describes the issue)
kind regards
RS

[Attaullah Shah]

ram singh asdoc creates files in the rich text format (RTF), when you edit the file with MS Word and save it, the file is converted to the native Word format and loses all functionalities of the RTF format. Therefore, asdoc cannot write to this file in RTF format anymore. So it is a good idea to first complete your tables and text writing from asdoc and then modify the file in MS Word.

[ram singh]

Got it Dr Shah !! thanks so much,
kind regards
RS