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)
How to use If condition to restrict t test on only two groups with a categorical var that has 3 groupsHi Family, I have 1 categorical variable that has 3 grps( blue,yellow, green), I wanted check if the…
specifying stored coefficients in testI am running two multilevel models and storing the coefficients. I then want to test of the product …
OLS vs. Ordered Logistic RegressionHello, I have five employee-level variables as below, and I was wondering if I could use the OLS wi…
Make a list table in StataDear Stata users, Thank you in advance. I want to make a table that has all items listed in cells t…
How to realize data deformation operationHow to perform the following data operations as follows: (1) Place the data scattered in multiple r…
Subscribe to:
Post Comments (Atom)
0 Response to Categorical variable per key (no unique keys)
Post a Comment