Greetings All,
I seem to have a problem in Stata that should be a pretty much straightforward to resolve, but nothing I have tried so far (including egen sum or collapse command), seems to work. I have a firm-level panel data for one country only. I am trying to calculate total employment over 5-year time periods. First, I use an egen sum command to sum up employment annually: egen yr_employment=sum(employment), by(year). However, instead of getting the figures on total annual employment, I get firm observations on employment counted. I have tried all possible solutions, and yet nothing worked yet. 'Employment' has a data storage format 'long'. I have read somewhere on Stata forum discussion that sometimes a 'long' format could cause issues as a variable seems to be wrongly treated as string, though it is a numeric. I have generated a new var with a float format, but this hasn't resolved the problem. And I am not sure if it's a 'long' data storage type that causes a problem in the first place. Any suggestions of how I could resolve this problem would be highly appreciated.
Related Posts with egen (sum) is not summing up absolute figures but counts a number of observations
Avergaing values of variables to reduce survey observationsHi, I am looking for a solution to average the survey respones. Below S007 is suvey respondent ID, …
Stata for loop errorHi, I am trying to run the below loop in stata. But i get an error. Can someone help me. I am a be…
Interpreting significant interaction effect while main effect is insignificantHi! I am investigating the effect of balanced ambidexterity and combined ambidexterity on firm perf…
Something wrong with -colorpalette-Dear Stata users, I have installed the -colorpalette- wrote by Ben Jann, and I remenber that it run…
how to know whether a placebo test is passedHello! I'm conducting a placebo test on a staggered DID, I randomly assign treatment firms and poli…
Subscribe to:
Post Comments (Atom)
0 Response to egen (sum) is not summing up absolute figures but counts a number of observations
Post a Comment