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
robust ANOVA for non-normal dataDear Statalist friends, I am unexperienced with most statistical methods and Stata and I need some …
just-identified IV with ivlasso and multiple endogenous variablesDear Statalist I would like to estimate an IV regression with a high-dimensional set of controls us…
Is difference in differences appropriate here?Here is the situation: There was an intervention T. I am interested in how this intervention change…
Help with loopingnHi Everyone, I have pasted below a screenshot of my dataset and of the variables I need to work wit…
Convert Single String Variable to Many Binary VariablesI have a variable for U.S. states that includes 01, 02, 03, ... , 50, 51, and these are all strings …
Subscribe to:
Post Comments (Atom)
0 Response to Collapse different columns differently
Post a Comment