ARCHIVED: 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, contact Research Analytics. Research Analytics is located on the IU Bloomington campus at Woodburn Hall 200; staff are available for consultation Monday-Friday 9am-noon and by appointment.
This is document aqdz in the Knowledge Base.
Last modified on 2015-06-30 00:00:00.
- 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.