Generating new variable for several observations

[Ali Taleb]

Hi Everyone,

I have this example below, where I have used "exapnd 12" to have each city 12 times. This is because I need to have years starting from 2007 and ending in 2018. So for each city I should generate a year. Can I do this in stata?

* Example generated by -dataex-. To install: ssc install dataex
clear
input byte district str20 city float LR
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
 8 "adelanto"       0
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
33 "agourahills"    1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "alameda"        1
13 "albany"         1
13 "albany"         1
13 "albany"         1
13 "albany"         1
13 "albany"         1
13 "albany"         1
13 "albany"         1
13 "albany"         1
13 "albany"         1
13 "albany"         1
13 "albany"         1
13 "albany"         1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
27 "alhambra"       1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
48 "alisoviejo"     1
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 1 "alturas"        0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 4 "amador"         0
 5 "americancanyon" 1
 5 "americancanyon" 1
 5 "americancanyon" 1
 5 "americancanyon" 1
end

Thank you
Ali

[Rich Goldstein]

if I understand you correctly, try this:

bys city: gen year=_n+2006

[Ali Taleb]

Thank you Rich. It works.