In Stata, how do I get aggregate statistics and save them into a data set?
Stata's 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:
Note that male is set to 1 for male and
0 for female. The new data set has two observations with
three variables: male, x1, and
x2.
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)For more about statistical and mathematical software, email the UITS Stat/Math Center, visit the center's web page, or phone 812-855-4724 (IUB) or 317-278-4740 (IUPUI). The center is located in Bloomington at 410 N. Park Avenue, and is open for consultation by appointment Monday-Friday 9am-5pm.
Last modified on May 04, 2011.
