Hi there,
I have the following code in stata:
*2018
*Form 4
generate Form4= 1 if Performance2018 ==1 & form== "4"
replace Form4= 0 if Performance2018==0 & form=="4"
replace Form4= 3 if Performance2018==3 & form=="4"
replace Form4= 5 if Performance2018==5 & form=="4"
label values Form4 Einteilung
*Distinct
egen tag2018 = tag(Form4 cik)
generate distinctform2018= 1 if tag2018 ==1 & Form4 == 1 & year ==2018
replace distinctform2018 = 3 if tag2018 ==1 & Form4 == 3 & year ==2018
replace distinctform2018 = 0 if tag2018 ==1 & Form4 == 0 & year ==2018
replace distinctform2018 = 5 if tag2018 ==1 & Form4 == 5 & year ==2018
label values distinctform2018 Einteilung
drop tag2018
*Average
egen tag2018 = tag(distinctform2018 Form4)
bysort cik Form4: gen Form4forms2018 = _N
generate Form4_gute2018= Form4forms2018 if Form4 ==1 & distinctform2018 == 1
generate Form4_schlechte2018= Form4forms2018 if Form4 ==0 & distinctform2018 == 0
drop Form4 distinctform2018 tag2018 Form4forms2018
My concern is to repeat this Code for every year till 2009. Is it possible with a for loop code that only the year (2018, 2017,2016,2015...) will change? Otherwise i have copy and paste the whole code and change the year manually.
Thank you a lot in advance!
Cheers,
Sergej
Related Posts with for loop
Value Labels and Appending DataI have a question about the appending data from multiple rounds of surveys across 10 countries from …
Calculation of Kolm–Pollack Index.Hello everybody! I.m trying to calculate the Kolm–Pollack Index of inequality for the distribution …
Parallel Coordinates and playing around with graphIn using the parcoord command, I am finding it difficult to move from the default colors provided by…
Adding Variables Gradually in RegressionsHi, I want to add multiple independent variables in the regressions gradually with the same depende…
Monthly last observation in a temporal seriesHi, I have a temporal series with the follow variables: idcompany, lastprice and date (dd/mm/yyyy). …
Subscribe to:
Post Comments (Atom)
0 Response to for loop
Post a Comment