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
Group of variables that explain most of the observationsHello. I am working on a dataset where people were asked whether they use certain media outlets or n…
Recode of two VariablesHello everyone, i have 20 different Variables for the religion of the interviewed. How can i create…
What's the syntax for panel ARDL model with CCEMG estimator? Should the xtmg command be used?Dear all, I am learning Stata and trying to figure out how to use the xtpmg command with CCE Mean G…
Panel Data Hausman test Hello, I am working with 10years and 46 countries data. All is fine until I tried the Hausman test.…
About Random Effects in a Multilevel Survival ModelGoodmorning everyone. My training is mainly clinical, and I would be grateful that I can be helped. …
Subscribe to:
Post Comments (Atom)
0 Response to Collapse different columns differently
Post a Comment