Below is a sample of data from my data set. The last column, NoBust, is how I want the variable to appear.
Year | Country | Country_2 | AllBuster | NoBust |
1972 | UK | Cuba | 0 | 0 |
1973 | UK | Cuba | 0 | 1 |
1972 | UK | Cuba | 1 | 2 |
1973 | UK | Cuba | 0 | 0 |
1974 | UK | Cuba | 0 | 1 |
1975 | UK | Cuba | 0 | 2 |
1976 | UK | Cuba | 0 | 3 |
1977 | UK | Cuba | 0 | 4 |
Year | Country | Country_2 | AllBuster | NoBust |
1972 | UK | Cuba | 0 | 0 |
1973 | UK | Cuba | 0 | 1 |
1972 | UK | Cuba | 1 | 0 |
1973 | UK | Cuba | 0 | 2 |
1974 | UK | Cuba | 0 | 3 |
1975 | UK | Cuba | 0 | 4 |
1976 | UK | Cuba | 0 | 5 |
1977 | UK | Cuba | 0 | 6 |
Code:
by partnercode targetcode (year), sort: gen nobust = (allbuster0 == 1) by partnercode targetcode (year): replace nobust = sum(nobust) by partnercode targetcode nobust (year), sort: gen nobust0 = _n-1 if nobust >=0 drop nobust
0 Response to Duration variable
Post a Comment