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:
. collapse (sum) x1 (mean) x2, by(male)
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. 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, see Research Analytics, or call 812-855-4724 (IUB) or 317-278-4740 (IUPUI).
This is document aqdz in the Knowledge Base.
Last modified on 2014-06-25.
- Fill out this form to submit your issue to the UITS Support Center.
- Please note that you must be affiliated with Indiana University to receive support.
- All fields are required.