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
Grouping Countries According To Level of GDP per capitaHello, I am very new to Stata and excuse me in advance if this is somewhat of an easy question to ta…
PLEASE HELP: "Convergence not achieved" errorHi, I am using xtgee command to estimate DP with IV in fractional form on a balanced panel data but …
Dynamic panel data - how to test coefficient stability?I have an unbalanced panel data and I want to run an ARDL model. The longest time-span is from 1950m…
Interpretation r.a#r.b interaction (margins command)Dear Statalisters, I ran the following logit model and then computed the marginal effects of my var…
Identifying First Occurrences in Panel DataDear Statalist Community, Set-up I am currently working with a database of executive compensation f…
Subscribe to:
Post Comments (Atom)
0 Response to Aggregate data by TWO groups
Post a Comment