Hi guys,
currently I am struggling with below table:
Array
The second column contains a combination of gvkey and year. This ID can occur several times, i.e. gvkey_year 002991_2015 occurs three times, for example.
Now I want to output one FundStage per gvkey_year. For example, if a gvkeyyear has one Later Stage and two Early Stages, a variable should output Early Stage. In total, the FundStage has the characteristics Early, Later and Seed Stage.
Is there a clean way to do this? I have tried various workarounds so far, but they have never been satisfactory.
Thank you very much!
Best regards
Related Posts with Categorical variable per key (no unique keys)
Panel data preparation and xtreg functionHi I am new to econometrics and stata, and appreciate some help for the following qns related to my…
How to fix heteroskedasticity and autocorrelation on OLSHi I did OLS test for my panel data ( n= 760 and t=8) and checked heteroskedasticity and autocorrela…
AR(1) and AR(2) test in dynamic panel GMM estimation?Hi, I am using diff-GMM and sys-GMM for an unbalanced panel with time (T=5) and country (N=84). I a…
the conclusion for the correlation of variablesHi I am doing with panel data ( N=760. T=8) / When I check the correlation of variables the result a…
svydescribe for mi set dataI have been hunting around and trying everything I can think of but cannot figure out how to get the…
Subscribe to:
Post Comments (Atom)
0 Response to Categorical variable per key (no unique keys)
Post a Comment