define persona.ciudadres
as recode PARROQ.REDCODEN 
( 180150 = 1 )
( 180152 = 1 )
( 180153 = 1 )
( 180155 = 1 )
( 180156 = 1 )
( 180160 = 1 )
( 180163 = 1 )
( 180165 = 1 )
( 180166 = 1 )
( 180850 = 1 )
( 70250 = 2 )
( 80650 = 3 )
( 80652 = 3 )
( 80654 = 3 )
( 100250 = 4 )
( 100252 = 4 )
( 100253 = 4 )
( 100254 = 4 )
( 30150 = 5 )
( 120150 = 6 )
( 131450 = 7 )
( 132250 = 7 )
( 90450 = 8 )
( 130250 = 9 )
( 110350 = 10 )
( 170250 = 11 )
( 170256 = 11 )
( 130350 = 12 )
( 10150 = 13 )
( 10151 = 13 )
( 10158 = 13 )
( 10162 = 13 )
( 10163 = 13 )
( 10165 = 13 )
( 10167 = 13 )
( 10169 = 13 )
( 10170 = 13 )
( 10152 = 13 )
( 10153 = 13 )
( 10154 = 13 )
( 10155 = 13 )
( 10156 = 13 )
( 10157 = 13 )
( 10159 = 13 )
( 10160 = 13 )
( 10161 = 13 )
( 10164 = 13 )
( 10166 = 13 )
( 10168 = 13 )
( 10171 = 13 )
( 130450 = 14 )
( 220150 = 15 )
( 70650 = 16 )
( 90950 = 17 )
( 80150 = 18 )
( 80166 = 18 )
( 80168 = 18 )
( 92150 = 19 )
( 20150 = 20 )
( 90150 = 21 )
( 90650 = 21 )
( 90656 = 21 )
( 90750 = 21 )
( 91650 = 21 )
( 92450 = 21 )
( 92550 = 21 )
( 90152 = 21 )
( 90153 = 21 )
( 90156 = 21 )
( 90157 = 21 )
( 90158 = 21 )
( 70750 = 22 )
( 100150 = 23 )
( 100154 = 23 )
( 100157 = 23 )
( 130650 = 24 )
( 230250 = 25 )
( 240150 = 26 )
( 240250 = 26 )
( 240350 = 26 )
( 240352 = 26 )
( 50250 = 27 )
( 30450 = 28 )
( 50150 = 29 )
( 110150 = 30 )
( 140150 = 31 )
( 140157 = 31 )
( 170350 = 32 )
( 170351 = 32 )
( 170352 = 32 )
( 70150 = 33 )
( 130850 = 34 )
( 130950 = 34 )
( 132150 = 34 )
( 91050 = 35 )
( 91051 = 35 )
( 91150 = 36 )
( 91250 = 37 )
( 210150 = 38 )
( 210158 = 38 )
( 100350 = 39 )
( 100356 = 39 )
( 100450 = 39 )
( 100451 = 39 )
( 100452 = 39 )
( 100453 = 39 )
( 100456 = 39 )
( 100457 = 39 )
( 100458 = 39 )
( 70950 = 40 )
( 131750 = 41 )
( 91450 = 42 )
( 130150 = 43 )
( 130151 = 43 )
( 130155 = 43 )
( 131250 = 43 )
( 131350 = 43 )
( 160150 = 44 )
( 160163 = 44 )
( 160252 = 44 )
( 120550 = 45 )
( 170150 = 46 )
( 170151 = 46 )
( 170152 = 46 )
( 170155 = 46 )
( 170156 = 46 )
( 170157 = 46 )
( 170159 = 46 )
( 170160 = 46 )
( 170162 = 46 )
( 170163 = 46 )
( 170164 = 46 )
( 170165 = 46 )
( 170170 = 46 )
( 170175 = 46 )
( 170177 = 46 )
( 170179 = 46 )
( 170180 = 46 )
( 170183 = 46 )
( 170184 = 46 )
( 170185 = 46 )
( 170186 = 46 )
( 170353 = 46 )
( 170356 = 46 )
( 170357 = 46 )
( 170550 = 46 )
( 170154 = 46 )
( 170166 = 46 )
( 170171 = 46 )
( 170176 = 46 )
( 60150 = 47 )
( 60155 = 47 )
( 60161 = 47 )
( 60750 = 47 )
( 80450 = 48 )
( 121050 = 49 )
( 92050 = 50 )
( 80550 = 51 )
( 71250 = 52 )
( 71251 = 52 )
( 230150 = 53 )
( 150150 = 54 )
( 150158 = 54 )
( 150350 = 54 )
( 40150 = 55 )
( 121150 = 56 )
( 90850 = 57 )
( 120750 = 58 )
( 120850 = 59 )
ELSE 0
RANGE 0:59
notapplicable 90
DEFAULT 99
MISSING 99
group    migra
varlabel "Ciudad de residencia habitual"
valuelabels
 0 "Otros"
 1 "Ambato"
 2 "Arenillas"
 3 "Atacames"
 4 "Atuntaqui"
 5 "Azogues"
 6 "Babahoyo"
 7 "Bahía de Caráquez"
 8 "Balzar"
 9 "Calceta"
10 "Catamayo"
11 "Cayambe"
12 "Chone"
13 "Cuenca"
14 "El Carmen"
15 "El Coca (Puerto Francisco de Orellana)"
16 "El Guabo"
17 "El Triunfo"
18 "Esmeraldas"
19 "General Villamil"
20 "Guaranda"
21 "Guayaquil"
22 "Huaquillas"
23 "Ibarra"
24 "Jipijapa"
25 "La Concordia"
26 "La Libertad"
27 "La Maná"
28 "La Troncal"
29 "Latacunga"
30 "Loja"
31 "Macas"
32 "Machachi"
33 "Machala"
34 "Manta"
35 "Milagro"
36 "Naranjal"
37 "Naranjito"
38 "Nueva Loja"
39 "Otavalo"
40 "Pasaje"
41 "Pedernales"
42 "Pedro Carbo"
43 "Portoviejo"
44 "Puyo"
45 "Quevedo"
46 "Quito"
47 "Riobamba"
48 "Rosa Zárate"
49 "San Jacinto de Buena Fe"
50 "San Jacinto de Yaguachi"
51 "San Lorenzo"
52 "Santa Rosa"
53 "Santo Domingo de los Colorados"
54 "Tena"
55 "Tulcán"
56 "Valencia"
57 "Velasco Ibarra"
58 "Ventanas"
59 "Vinces"
save "C:\2025\ECUADOR\2022\CIUDADES\vars\persona-ciudadres"

define persona.ciudadres5
as recode PERSONA.P09Q  
( 180150 = 1 )
( 180152 = 1 )
( 180153 = 1 )
( 180155 = 1 )
( 180156 = 1 )
( 180160 = 1 )
( 180163 = 1 )
( 180165 = 1 )
( 180166 = 1 )
( 180850 = 1 )
( 70250 = 2 )
( 80650 = 3 )
( 80652 = 3 )
( 80654 = 3 )
( 100250 = 4 )
( 100252 = 4 )
( 100253 = 4 )
( 100254 = 4 )
( 30150 = 5 )
( 120150 = 6 )
( 131450 = 7 )
( 132250 = 7 )
( 90450 = 8 )
( 130250 = 9 )
( 110350 = 10 )
( 170250 = 11 )
( 170256 = 11 )
( 130350 = 12 )
( 10150 = 13 )
( 10151 = 13 )
( 10158 = 13 )
( 10162 = 13 )
( 10163 = 13 )
( 10165 = 13 )
( 10167 = 13 )
( 10169 = 13 )
( 10170 = 13 )
( 10152 = 13 )
( 10153 = 13 )
( 10154 = 13 )
( 10155 = 13 )
( 10156 = 13 )
( 10157 = 13 )
( 10159 = 13 )
( 10160 = 13 )
( 10161 = 13 )
( 10164 = 13 )
( 10166 = 13 )
( 10168 = 13 )
( 10171 = 13 )
( 130450 = 14 )
( 220150 = 15 )
( 70650 = 16 )
( 90950 = 17 )
( 80150 = 18 )
( 80166 = 18 )
( 80168 = 18 )
( 92150 = 19 )
( 20150 = 20 )
( 90150 = 21 )
( 90650 = 21 )
( 90656 = 21 )
( 90750 = 21 )
( 91650 = 21 )
( 92450 = 21 )
( 92550 = 21 )
( 90152 = 21 )
( 90153 = 21 )
( 90156 = 21 )
( 90157 = 21 )
( 90158 = 21 )
( 70750 = 22 )
( 100150 = 23 )
( 100154 = 23 )
( 100157 = 23 )
( 130650 = 24 )
( 230250 = 25 )
( 240150 = 26 )
( 240250 = 26 )
( 240350 = 26 )
( 240352 = 26 )
( 50250 = 27 )
( 30450 = 28 )
( 50150 = 29 )
( 110150 = 30 )
( 140150 = 31 )
( 140157 = 31 )
( 170350 = 32 )
( 170351 = 32 )
( 170352 = 32 )
( 70150 = 33 )
( 130850 = 34 )
( 130950 = 34 )
( 132150 = 34 )
( 91050 = 35 )
( 91051 = 35 )
( 91150 = 36 )
( 91250 = 37 )
( 210150 = 38 )
( 210158 = 38 )
( 100350 = 39 )
( 100356 = 39 )
( 100450 = 39 )
( 100451 = 39 )
( 100452 = 39 )
( 100453 = 39 )
( 100456 = 39 )
( 100457 = 39 )
( 100458 = 39 )
( 70950 = 40 )
( 131750 = 41 )
( 91450 = 42 )
( 130150 = 43 )
( 130151 = 43 )
( 130155 = 43 )
( 131250 = 43 )
( 131350 = 43 )
( 160150 = 44 )
( 160163 = 44 )
( 160252 = 44 )
( 120550 = 45 )
( 170150 = 46 )
( 170151 = 46 )
( 170152 = 46 )
( 170155 = 46 )
( 170156 = 46 )
( 170157 = 46 )
( 170159 = 46 )
( 170160 = 46 )
( 170162 = 46 )
( 170163 = 46 )
( 170164 = 46 )
( 170165 = 46 )
( 170170 = 46 )
( 170175 = 46 )
( 170177 = 46 )
( 170179 = 46 )
( 170180 = 46 )
( 170183 = 46 )
( 170184 = 46 )
( 170185 = 46 )
( 170186 = 46 )
( 170353 = 46 )
( 170356 = 46 )
( 170357 = 46 )
( 170550 = 46 )
( 170154 = 46 )
( 170166 = 46 )
( 170171 = 46 )
( 170176 = 46 )
( 60150 = 47 )
( 60155 = 47 )
( 60161 = 47 )
( 60750 = 47 )
( 80450 = 48 )
( 121050 = 49 )
( 92050 = 50 )
( 80550 = 51 )
( 71250 = 52 )
( 71251 = 52 )
( 230150 = 53 )
( 150150 = 54 )
( 150158 = 54 )
( 150350 = 54 )
( 40150 = 55 )
( 121150 = 56 )
( 90850 = 57 )
( 120750 = 58 )
( 120850 = 59 )
ELSE 0
FILTER PERSONA.P09Q  < 240353 and edad > 4
RANGE 0:59
notapplicable 90
DEFAULT 99
MISSING 99
group    migra
varlabel  "Ciudad de residencia hace 5 años"
valuelabels
 0 "Otros"
 1 "Ambato"
 2 "Arenillas"
 3 "Atacames"
 4 "Atuntaqui"
 5 "Azogues"
 6 "Babahoyo"
 7 "Bahía de Caráquez"
 8 "Balzar"
 9 "Calceta"
10 "Catamayo"
11 "Cayambe"
12 "Chone"
13 "Cuenca"
14 "El Carmen"
15 "El Coca (Puerto Francisco de Orellana)"
16 "El Guabo"
17 "El Triunfo"
18 "Esmeraldas"
19 "General Villamil"
20 "Guaranda"
21 "Guayaquil"
22 "Huaquillas"
23 "Ibarra"
24 "Jipijapa"
25 "La Concordia"
26 "La Libertad"
27 "La Maná"
28 "La Troncal"
29 "Latacunga"
30 "Loja"
31 "Macas"
32 "Machachi"
33 "Machala"
34 "Manta"
35 "Milagro"
36 "Naranjal"
37 "Naranjito"
38 "Nueva Loja"
39 "Otavalo"
40 "Pasaje"
41 "Pedernales"
42 "Pedro Carbo"
43 "Portoviejo"
44 "Puyo"
45 "Quevedo"
46 "Quito"
47 "Riobamba"
48 "Rosa Zárate"
49 "San Jacinto de Buena Fe"
50 "San Jacinto de Yaguachi"
51 "San Lorenzo"
52 "Santa Rosa"
53 "Santo Domingo de los Colorados"
54 "Tena"
55 "Tulcán"
56 "Valencia"
57 "Velasco Ibarra"
58 "Ventanas"
59 "Vinces"
save "C:\2025\ECUADOR\2022\CIUDADES\vars\persona-ciudadres5"

table EC22C5MB
FREQ  CIUDADRES BY CIUDADRES5