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)
Storing the results of suest on MI dataDear Statalist users, I am doing an analysis where I want to compare whether some associations diffe…
rdplot weight the linear function of dependent variable by the number of observations in each binHi all, I am currently using rdplot to visualise the discontinuity of my outcome variable along the…
Delete variables that have the same number repeated across all observations with some missing values.I have a dataset with ~2500 variables named NEIS* and I want to: - Delete all variables that have th…
Help with data set-upHello all- I feel like there is an easy solution to this but I just can't see how to do it. I have d…
Coefplot: Group covariates by model, and not model by covariatesI am trying to plot estimates from multiple models using coefplot. I need to group all the estimates…
Subscribe to:
Post Comments (Atom)
0 Response to Categorical variable per key (no unique keys)
Post a Comment