In Stata, how do I get aggregate statistics and save them into a data set?
collapse command computes aggregate
statistics such as mean, sum, and standard deviation and saves them
into a data set. When you execute the command, an existing data set is
replaced with the new one containing aggregate data.
Suppose you want to get the sum of a variable
x1 and the
mean of a variable
x2 for males and females
separately. Consider the following example:
male is set to
1 for male and
0 for female. The new data set has two observations with
If you want to save into different variable names, specify the names, for example:. collapse (sum) new_x1=x1 (mean) new_x2=x2, by(male)
If you have questions about using statistical and mathematical software at Indiana University, email UITS Research Analytics (formerly known as the Stat/Math Center). Research Analytics is located on the IU Bloomington campus at Woodburn Hall 200, and is open for consultation by appointment Monday-Friday 9am-5pm. For more, visit Research Analytics on the web, or call 812-855-4724 (IUB) or 317-278-4740 (IUPUI).
Last modified on September 25, 2012.