Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down at the end of May, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Nick Cox <njcoxstata@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Exporting descriptive statistics to excel |

Date |
Mon, 12 Sep 2011 13:33:37 +0100 |

I don't think anything in your question calls for use of MS Excel. Have a look at -tabstat- or -collapse-. -tabstat- will show a table of summary statistics very easily. Whether the variable names are structured is immaterial. Similar comments on -collapse-. Nick On Mon, Sep 12, 2011 at 1:23 PM, Kyle Peyton <kyle.peyton@unimelb.edu.au> wrote: > I've been trying to work out something that I think should be pretty simple. I have a large time series dataset and I want to examine the very basic summary statistics that are reported by the sum command for several select variables across 9 years. The code I have written to accomplish this in Stata is the following: > > > forvalues year = 2000/2009 { > foreach x of varlist `list1' { > display `year' > sum `x' if year == `year' > } > } > > Which loops through and gives me the summary statistics for each variable in each year. Unfortunately this is quite a long list. Is it possible to export the data to excel and have a look at each variable across each year, so my top excel row would look like this: Year Variable Obs Mean Std. Dev. Min Max for a total of 8 columns, which would contain all my summary statistics? I realize it may be better if I first rename all the variables in `list1' to include a _year suffix and thereby reduce my desired excel column width to 7 before trying to export. Any suggestions would be greatly appreciated. > * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**RE: st: Exporting descriptive statistics to excel***From:*Kyle Peyton <kyle.peyton@unimelb.edu.au>

**References**:**st: Exporting descriptive statistics to excel***From:*Kyle Peyton <kyle.peyton@unimelb.edu.au>

- Prev by Date:
**Re: st: A loop for each couple of variables (instead of for each variable)** - Next by Date:
**st: Exporting descriptive statistics to excel** - Previous by thread:
**st: Exporting descriptive statistics to excel** - Next by thread:
**RE: st: Exporting descriptive statistics to excel** - Index(es):