In a panel database of companies (bisnode), the revenue information is not always for the full year...sometimes it's quarterly, for example...
So I want to collapse rows such that rows that belong to the same company for the same year are merged. Not just that, I want most columns to average out, but I 2 columns to aggregate (sum).
Can I even run collapse such that it runs differently (average v sum) on different columns?
Related Posts with Collapse different columns differently
regressing group observations identified by id in loop and for each regression create a table output- Change in the default bandwidth of -lpoly- from Stata 15/16 to 17
- Variables not constant within table
- Drop observations for date A if > 90 days before or after date B
- Single-item outcome in an intervention effect
Subscribe to:
Post Comments (Atom)
0 Response to Collapse different columns differently
Post a Comment