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
Calculating Sample size for a quasi experimental designHello, I need help with calculating sample size for a quasi-experimental design (Pre test-post test …
Import excel date format instead of general numberHi, I'm importing an excel spreadsheet (downloaded/refreshed from Datastream, the data provider) bu…
report var(residual) / melogit vs. xtmixed ?l am working about cross-classified multilevel model dependent variable : immigration y/n (binary, …
How to count the number of missing values?How to count the number of missing values? I have a simple question I would like to know asap. How …
rename all variablesHello everyone, I am trying to rename ALL variables in my dataset. The end results are supposed to …
Subscribe to:
Post Comments (Atom)
0 Response to Aggregate data by TWO groups
Post a Comment