Hi everyone,
I have a dataset on companies, its financial years, matching financial numbers and error years.
Some of the companies have years where errors have occurred. For those companies, there is a variable with the year where the error has occurred (but only for the observation of the suitable year). There are always other observations for the same company in different financial years, but without the year of the error. I need to add the year of the error to every observation of the company that had an error.
I already created groups for every company (using "egen"), but I don't know how to add the error financial year variable to the other observation of the respective company.
Can someone help?
Example:
Company financial year error_year
1. Company1 2014 -
2. Company1 2015 2015
3. Company1 2016 -
4. Company1 2017 -
My goal is to have the error year (2015) for every observation of Company1.
Thanks in advance,
Judith
Related Posts with add values to certain groups
SubanalysisHello, I have a few questions regarding interaction terms. 1. If I have my final logistic regressi…
How to Handle Heterogeneity in Panel Data using Systems GMM approachDear Stata Users, I am currently researching on Foreign direct investment in Africa using the Syste…
Create graph with different colors when y<0Hello, I would like to know the code to create a graph (lines) with the y values (in this case "dif…
How to model "Sparial Variability" or "Choice of Location"I have a survey data on 10000 delivery person. I have number of delivery they made in 49 neighborhoo…
Venn diagramHi I'm trying to do a Venn diagram with 4 variables but the code pvenn allows only 3 variables maxim…
Subscribe to:
Post Comments (Atom)
0 Response to add values to certain groups
Post a Comment