Hey everyone, I'm new to Stata and have a question.
I need to aggregate the data by year and company. With the collapse function, I can only sum up the values for the companies for all years.
The raw data look like this:
id year companyid sales
1 2010 555 50,000
2 2010 555 46,000
3 2010 555 40,000
4 2011 555 30,000
5 2011 555 51,000
6 2010 700 2,000
7 2010 700 4,000
8 2011 700 7,000
9 2011 700 11,000
10 2011 700 5,000
.....
The result I need, should look like this:
year companyid Sum
2010 555 136,000
2010 700 6,000
2011 555 81,000
2011 700 23,000
.....
I appreciate any thoughts, many thanks!
Related Posts with Aggregate data by TWO groups
OLS and GMM regression on insurance dataI have some insurance data and I want to make a) an OLS regression and b) an GMM regression on th…
Behavior of tempvar within ML programSuppose I know the mean of a normal variable and I want to estimate its standard deviation using MLE…
graph with mean along 90% confidence interval?Dear All, I have the following data Code: * Example generated by -dataex-. To install: ssc install …
What commands would be needed to create this tableI want to create a mean randomization check table for a RCT. Basically I want to generate a table li…
Extract p-value of independent variable ologitHello, I am trying to extract the p-value of an independent variable after an ologit. It seems like…
Subscribe to:
Post Comments (Atom)
0 Response to Aggregate data by TWO groups
Post a Comment