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