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
Date Help: (DM) Dates without Years and Unequal IntervalsSorry this is a very basic problem. I have a time series covering 1.5 years. The datevar is a string…
Interacting variablesHello, I need some help. I'm doing my master thesis about renewable energies and politics I have a …
expanding datasetDear all I have a dataset as follows: Code: clear input byte loan_id int lender_id byte key_lend…
Finding the mode value in aggregated spatial unitsHello, I have a dataset with two geographical units of observations, districts and labor market reg…
Keep time within a range from DateTimeHi Everyone! I am writing my dissertation which is on "The Impact of Macroeconomic Announcements on…
Subscribe to:
Post Comments (Atom)
0 Response to add values to certain groups
Post a Comment