DEFINE PERSONA.TAMANORES AS RECODE PERSONA.ciudadres ( 0 = 0 ) ( 398 = 1 ) ( 362 = 1 ) ( 193 = 1 ) ( 376 = 1 ) ( 389 = 1 ) ( 387 = 1 ) ( 364 = 1 ) ( 77 = 1 ) ( 399 = 1 ) ( 381 = 2 ) ( 365 = 2 ) ( 378 = 2 ) ( 361 = 2 ) ( 357 = 2 ) ( 355 = 2 ) ( 187 = 2 ) ( 382 = 2 ) ( 83 = 2 ) ( 122 = 2 ) ( 96 = 2 ) ( 353 = 2 ) ( 393 = 2 ) ( 379 = 2 ) ( 368 = 2 ) ( 356 = 2 ) ( 392 = 2 ) ( 394 = 2 ) ( 395 = 2 ) ( 370 = 2 ) ( 100 = 2 ) ( 181 = 3 ) ( 388 = 3 ) ( 137 = 3 ) ( 53 = 3 ) ( 184 = 3 ) ( 373 = 3 ) ( 105 = 3 ) ( 205 = 3 ) ( 386 = 3 ) ( 79 = 3 ) ( 372 = 3 ) ( 377 = 3 ) ( 360 = 3 ) ( 10 = 3 ) ( 375 = 3 ) ( 358 = 3 ) ( 367 = 3 ) ( 82 = 3 ) ( 359 = 3 ) ( 321 = 3 ) ( 384 = 3 ) ( 396 = 3 ) ( 366 = 3 ) ( 352 = 3 ) ( 48 = 3 ) ( 281 = 3 ) ( 161 = 3 ) ( 397 = 3 ) ( 170 = 3 ) ( 201 = 3 ) ( 66 = 3 ) ( 73 = 3 ) ( 238 = 3 ) ( 119 = 3 ) ( 252 = 3 ) ( 59 = 3 ) ( 391 = 3 ) ( 374 = 3 ) ( 390 = 3 ) ( 363 = 3 ) ( 78 = 3 ) ( 255 = 3 ) ( 50 = 3 ) ( 244 = 3 ) ( 223 = 3 ) ( 113 = 3 ) ( 176 = 3 ) ( 400 = 3 ) ( 328 = 3 ) ( 385 = 3 ) ( 383 = 3 ) ( 369 = 3 ) ( 98 = 3 ) ( 94 = 3 ) ( 136 = 3 ) ( 81 = 3 ) ( 371 = 3 ) ( 199 = 3 ) ( 401 = 3 ) ( 295 = 3 ) ( 249 = 3 ) ( 320 = 3 ) ( 124 = 3 ) ( 163 = 3 ) ( 23 = 3 ) ( 141 = 3 ) ( 31 = 4 ) ( 87 = 4 ) ( 75 = 4 ) ( 348 = 4 ) ( 351 = 4 ) ( 74 = 4 ) ( 158 = 4 ) ( 380 = 4 ) ( 354 = 4 ) ( 180 = 4 ) ( 182 = 4 ) ( 86 = 4 ) ( 9 = 4 ) ( 125 = 4 ) ( 93 = 4 ) ( 242 = 4 ) ( 257 = 4 ) ( 200 = 4 ) ( 300 = 4 ) ( 130 = 4 ) ( 282 = 4 ) ( 133 = 4 ) ( 127 = 4 ) ( 324 = 4 ) ( 173 = 4 ) ( 118 = 4 ) ( 3 = 4 ) ( 333 = 4 ) ( 237 = 4 ) ( 206 = 4 ) ( 91 = 4 ) ( 217 = 4 ) ( 185 = 4 ) ( 241 = 4 ) ( 42 = 4 ) ( 167 = 4 ) ( 322 = 4 ) ( 144 = 4 ) ( 346 = 4 ) ( 254 = 4 ) ( 259 = 4 ) ( 99 = 4 ) ( 297 = 4 ) ( 229 = 4 ) ( 235 = 4 ) ( 2 = 4 ) ( 246 = 4 ) ( 325 = 4 ) ( 24 = 4 ) ( 204 = 4 ) ( 284 = 4 ) ( 272 = 4 ) ( 88 = 4 ) ( 30 = 4 ) ( 250 = 4 ) ( 126 = 4 ) ( 296 = 4 ) ( 22 = 4 ) ( 227 = 4 ) ( 224 = 4 ) ( 56 = 4 ) ( 219 = 4 ) ( 307 = 4 ) ( 131 = 5 ) ( 303 = 5 ) ( 315 = 5 ) ( 97 = 5 ) ( 291 = 5 ) ( 218 = 5 ) ( 275 = 5 ) ( 337 = 5 ) ( 311 = 5 ) ( 299 = 5 ) ( 157 = 5 ) ( 63 = 5 ) ( 215 = 5 ) ( 264 = 5 ) ( 90 = 5 ) ( 192 = 5 ) ( 34 = 5 ) ( 68 = 5 ) ( 209 = 5 ) ( 39 = 5 ) ( 57 = 5 ) ( 329 = 5 ) ( 164 = 5 ) ( 212 = 5 ) ( 343 = 5 ) ( 107 = 5 ) ( 207 = 5 ) ( 179 = 5 ) ( 6 = 5 ) ( 51 = 5 ) ( 150 = 5 ) ( 110 = 5 ) ( 147 = 5 ) ( 45 = 5 ) ( 172 = 5 ) ( 128 = 5 ) ( 139 = 5 ) ( 54 = 5 ) ( 230 = 5 ) ( 89 = 5 ) ( 70 = 5 ) ( 151 = 5 ) ( 231 = 5 ) ( 72 = 5 ) ( 312 = 5 ) ( 245 = 5 ) ( 335 = 5 ) ( 8 = 5 ) ( 160 = 5 ) ( 103 = 5 ) ( 196 = 5 ) ( 251 = 5 ) ( 17 = 5 ) ( 203 = 5 ) ( 46 = 5 ) ( 21 = 5 ) ( 7 = 5 ) ( 32 = 5 ) ( 13 = 5 ) ( 102 = 5 ) ( 326 = 5 ) ( 247 = 5 ) ( 44 = 5 ) ( 152 = 5 ) ( 101 = 5 ) ( 274 = 5 ) ( 260 = 5 ) ( 285 = 5 ) ( 233 = 5 ) ( 302 = 5 ) ( 216 = 5 ) ( 156 = 5 ) ( 301 = 5 ) ( 155 = 5 ) ( 292 = 5 ) ( 67 = 5 ) ( 268 = 5 ) ( 236 = 5 ) ( 135 = 5 ) ( 106 = 5 ) ( 287 = 5 ) ( 49 = 5 ) ( 277 = 5 ) ( 1 = 5 ) ( 213 = 5 ) ( 280 = 5 ) ( 108 = 5 ) ( 104 = 5 ) ( 129 = 5 ) ( 342 = 5 ) ( 323 = 5 ) ( 305 = 5 ) ( 211 = 5 ) ( 298 = 5 ) ( 186 = 5 ) ( 112 = 5 ) ( 283 = 5 ) ( 168 = 5 ) ( 319 = 5 ) ( 309 = 5 ) ( 191 = 5 ) ( 220 = 5 ) ( 293 = 5 ) ( 12 = 5 ) ( 33 = 5 ) ( 266 = 5 ) ( 41 = 5 ) ( 174 = 5 ) ( 288 = 5 ) ( 69 = 5 ) ( 240 = 5 ) ( 341 = 5 ) ( 149 = 5 ) ( 27 = 5 ) ( 270 = 5 ) ( 92 = 5 ) ( 290 = 5 ) ( 248 = 5 ) ( 52 = 5 ) ( 80 = 5 ) ( 265 = 5 ) ( 310 = 5 ) ( 20 = 5 ) ( 71 = 5 ) ( 116 = 5 ) ( 169 = 5 ) ( 47 = 5 ) ( 232 = 5 ) ( 336 = 5 ) ( 190 = 5 ) ( 226 = 5 ) ( 138 = 5 ) ( 258 = 5 ) ( 35 = 5 ) ( 197 = 5 ) ( 36 = 5 ) ( 347 = 5 ) ( 153 = 5 ) ( 146 = 5 ) ( 76 = 5 ) ( 263 = 5 ) ( 210 = 5 ) ( 340 = 5 ) ( 214 = 5 ) ( 345 = 5 ) ( 19 = 5 ) ( 318 = 5 ) ( 194 = 5 ) ( 316 = 5 ) ( 16 = 5 ) ( 183 = 5 ) ( 189 = 5 ) ( 175 = 5 ) ( 195 = 5 ) ( 165 = 5 ) ( 289 = 5 ) ( 330 = 5 ) ( 109 = 5 ) ( 64 = 5 ) ( 114 = 5 ) ( 188 = 5 ) ( 278 = 5 ) ( 262 = 5 ) ( 111 = 5 ) ( 142 = 5 ) ( 61 = 5 ) ( 148 = 5 ) ( 117 = 5 ) ( 304 = 5 ) ( 60 = 5 ) ( 279 = 5 ) ( 286 = 5 ) ( 267 = 5 ) ( 208 = 5 ) ( 276 = 5 ) ( 132 = 5 ) ( 143 = 5 ) ( 171 = 5 ) ( 221 = 5 ) ( 55 = 5 ) ( 134 = 5 ) ( 243 = 5 ) ( 14 = 5 ) ( 202 = 5 ) ( 120 = 5 ) ( 273 = 0 ) ( 294 = 0 ) ( 256 = 0 ) ( 313 = 0 ) ( 234 = 0 ) ( 162 = 0 ) ( 350 = 0 ) ( 198 = 0 ) ( 58 = 0 ) ( 43 = 0 ) ( 271 = 0 ) ( 4 = 0 ) ( 253 = 0 ) ( 85 = 0 ) ( 339 = 0 ) ( 40 = 0 ) ( 140 = 0 ) ( 37 = 0 ) ( 154 = 0 ) ( 225 = 0 ) ( 15 = 0 ) ( 123 = 0 ) ( 95 = 0 ) ( 178 = 0 ) ( 177 = 0 ) ( 332 = 0 ) ( 62 = 0 ) ( 159 = 0 ) ( 28 = 0 ) ( 84 = 0 ) ( 115 = 0 ) ( 317 = 0 ) ( 25 = 0 ) ( 314 = 0 ) ( 121 = 0 ) ( 65 = 0 ) ( 26 = 0 ) ( 239 = 0 ) ( 222 = 0 ) ( 5 = 0 ) ( 331 = 0 ) ( 327 = 0 ) ( 349 = 0 ) ( 166 = 0 ) ( 145 = 0 ) ( 18 = 0 ) ( 308 = 0 ) ( 29 = 0 ) ( 269 = 0 ) ( 334 = 0 ) ELSE 999 RANGE 0 : 5 VARLABEL "Tamaño de la ciudad (habitual)" VALUELABELS 0 " Otro " 1 " 1 MILLON O MAS " 2 " 500.000-999.999 " 3 " 100.000-499.999 " 4 " 50.000-99.999 " 5 " 20.000-49.999 " SAVE "TAMANORES" OVERWRITE DEFINE PERSONA.TAMANORES5 AS RECODE PERSONA.ciudadres5 ( 0 = 0 ) ( 398 = 1 ) ( 362 = 1 ) ( 193 = 1 ) ( 376 = 1 ) ( 389 = 1 ) ( 387 = 1 ) ( 364 = 1 ) ( 77 = 1 ) ( 399 = 1 ) ( 381 = 2 ) ( 365 = 2 ) ( 378 = 2 ) ( 361 = 2 ) ( 357 = 2 ) ( 355 = 2 ) ( 187 = 2 ) ( 382 = 2 ) ( 83 = 2 ) ( 122 = 2 ) ( 96 = 2 ) ( 353 = 2 ) ( 393 = 2 ) ( 379 = 2 ) ( 368 = 2 ) ( 356 = 2 ) ( 392 = 2 ) ( 394 = 2 ) ( 395 = 2 ) ( 370 = 2 ) ( 100 = 2 ) ( 181 = 3 ) ( 388 = 3 ) ( 137 = 3 ) ( 53 = 3 ) ( 184 = 3 ) ( 373 = 3 ) ( 105 = 3 ) ( 205 = 3 ) ( 386 = 3 ) ( 79 = 3 ) ( 372 = 3 ) ( 377 = 3 ) ( 360 = 3 ) ( 10 = 3 ) ( 375 = 3 ) ( 358 = 3 ) ( 367 = 3 ) ( 82 = 3 ) ( 359 = 3 ) ( 321 = 3 ) ( 384 = 3 ) ( 396 = 3 ) ( 366 = 3 ) ( 352 = 3 ) ( 48 = 3 ) ( 281 = 3 ) ( 161 = 3 ) ( 397 = 3 ) ( 170 = 3 ) ( 201 = 3 ) ( 66 = 3 ) ( 73 = 3 ) ( 238 = 3 ) ( 119 = 3 ) ( 252 = 3 ) ( 59 = 3 ) ( 391 = 3 ) ( 374 = 3 ) ( 390 = 3 ) ( 363 = 3 ) ( 78 = 3 ) ( 255 = 3 ) ( 50 = 3 ) ( 244 = 3 ) ( 223 = 3 ) ( 113 = 3 ) ( 176 = 3 ) ( 400 = 3 ) ( 328 = 3 ) ( 385 = 3 ) ( 383 = 3 ) ( 369 = 3 ) ( 98 = 3 ) ( 94 = 3 ) ( 136 = 3 ) ( 81 = 3 ) ( 371 = 3 ) ( 199 = 3 ) ( 401 = 3 ) ( 295 = 3 ) ( 249 = 3 ) ( 320 = 3 ) ( 124 = 3 ) ( 163 = 3 ) ( 23 = 3 ) ( 141 = 3 ) ( 31 = 4 ) ( 87 = 4 ) ( 75 = 4 ) ( 348 = 4 ) ( 351 = 4 ) ( 74 = 4 ) ( 158 = 4 ) ( 380 = 4 ) ( 354 = 4 ) ( 180 = 4 ) ( 182 = 4 ) ( 86 = 4 ) ( 9 = 4 ) ( 125 = 4 ) ( 93 = 4 ) ( 242 = 4 ) ( 257 = 4 ) ( 200 = 4 ) ( 300 = 4 ) ( 130 = 4 ) ( 282 = 4 ) ( 133 = 4 ) ( 127 = 4 ) ( 324 = 4 ) ( 173 = 4 ) ( 118 = 4 ) ( 3 = 4 ) ( 333 = 4 ) ( 237 = 4 ) ( 206 = 4 ) ( 91 = 4 ) ( 217 = 4 ) ( 185 = 4 ) ( 241 = 4 ) ( 42 = 4 ) ( 167 = 4 ) ( 322 = 4 ) ( 144 = 4 ) ( 346 = 4 ) ( 254 = 4 ) ( 259 = 4 ) ( 99 = 4 ) ( 297 = 4 ) ( 229 = 4 ) ( 235 = 4 ) ( 2 = 4 ) ( 246 = 4 ) ( 325 = 4 ) ( 24 = 4 ) ( 204 = 4 ) ( 284 = 4 ) ( 272 = 4 ) ( 88 = 4 ) ( 30 = 4 ) ( 250 = 4 ) ( 126 = 4 ) ( 296 = 4 ) ( 22 = 4 ) ( 227 = 4 ) ( 224 = 4 ) ( 56 = 4 ) ( 219 = 4 ) ( 307 = 4 ) ( 131 = 5 ) ( 303 = 5 ) ( 315 = 5 ) ( 97 = 5 ) ( 291 = 5 ) ( 218 = 5 ) ( 275 = 5 ) ( 337 = 5 ) ( 311 = 5 ) ( 299 = 5 ) ( 157 = 5 ) ( 63 = 5 ) ( 215 = 5 ) ( 264 = 5 ) ( 90 = 5 ) ( 192 = 5 ) ( 34 = 5 ) ( 68 = 5 ) ( 209 = 5 ) ( 39 = 5 ) ( 57 = 5 ) ( 329 = 5 ) ( 164 = 5 ) ( 212 = 5 ) ( 343 = 5 ) ( 107 = 5 ) ( 207 = 5 ) ( 179 = 5 ) ( 6 = 5 ) ( 51 = 5 ) ( 150 = 5 ) ( 110 = 5 ) ( 147 = 5 ) ( 45 = 5 ) ( 172 = 5 ) ( 128 = 5 ) ( 139 = 5 ) ( 54 = 5 ) ( 230 = 5 ) ( 89 = 5 ) ( 70 = 5 ) ( 151 = 5 ) ( 231 = 5 ) ( 72 = 5 ) ( 312 = 5 ) ( 245 = 5 ) ( 335 = 5 ) ( 8 = 5 ) ( 160 = 5 ) ( 103 = 5 ) ( 196 = 5 ) ( 251 = 5 ) ( 17 = 5 ) ( 203 = 5 ) ( 46 = 5 ) ( 21 = 5 ) ( 7 = 5 ) ( 32 = 5 ) ( 13 = 5 ) ( 102 = 5 ) ( 326 = 5 ) ( 247 = 5 ) ( 44 = 5 ) ( 152 = 5 ) ( 101 = 5 ) ( 274 = 5 ) ( 260 = 5 ) ( 285 = 5 ) ( 233 = 5 ) ( 302 = 5 ) ( 216 = 5 ) ( 156 = 5 ) ( 301 = 5 ) ( 155 = 5 ) ( 292 = 5 ) ( 67 = 5 ) ( 268 = 5 ) ( 236 = 5 ) ( 135 = 5 ) ( 106 = 5 ) ( 287 = 5 ) ( 49 = 5 ) ( 277 = 5 ) ( 1 = 5 ) ( 213 = 5 ) ( 280 = 5 ) ( 108 = 5 ) ( 104 = 5 ) ( 129 = 5 ) ( 342 = 5 ) ( 323 = 5 ) ( 305 = 5 ) ( 211 = 5 ) ( 298 = 5 ) ( 186 = 5 ) ( 112 = 5 ) ( 283 = 5 ) ( 168 = 5 ) ( 319 = 5 ) ( 309 = 5 ) ( 191 = 5 ) ( 220 = 5 ) ( 293 = 5 ) ( 12 = 5 ) ( 33 = 5 ) ( 266 = 5 ) ( 41 = 5 ) ( 174 = 5 ) ( 288 = 5 ) ( 69 = 5 ) ( 240 = 5 ) ( 341 = 5 ) ( 149 = 5 ) ( 27 = 5 ) ( 270 = 5 ) ( 92 = 5 ) ( 290 = 5 ) ( 248 = 5 ) ( 52 = 5 ) ( 80 = 5 ) ( 265 = 5 ) ( 310 = 5 ) ( 20 = 5 ) ( 71 = 5 ) ( 116 = 5 ) ( 169 = 5 ) ( 47 = 5 ) ( 232 = 5 ) ( 336 = 5 ) ( 190 = 5 ) ( 226 = 5 ) ( 138 = 5 ) ( 258 = 5 ) ( 35 = 5 ) ( 197 = 5 ) ( 36 = 5 ) ( 347 = 5 ) ( 153 = 5 ) ( 146 = 5 ) ( 76 = 5 ) ( 263 = 5 ) ( 210 = 5 ) ( 340 = 5 ) ( 214 = 5 ) ( 345 = 5 ) ( 19 = 5 ) ( 318 = 5 ) ( 194 = 5 ) ( 316 = 5 ) ( 16 = 5 ) ( 183 = 5 ) ( 189 = 5 ) ( 175 = 5 ) ( 195 = 5 ) ( 165 = 5 ) ( 289 = 5 ) ( 330 = 5 ) ( 109 = 5 ) ( 64 = 5 ) ( 114 = 5 ) ( 188 = 5 ) ( 278 = 5 ) ( 262 = 5 ) ( 111 = 5 ) ( 142 = 5 ) ( 61 = 5 ) ( 148 = 5 ) ( 117 = 5 ) ( 304 = 5 ) ( 60 = 5 ) ( 279 = 5 ) ( 286 = 5 ) ( 267 = 5 ) ( 208 = 5 ) ( 276 = 5 ) ( 132 = 5 ) ( 143 = 5 ) ( 171 = 5 ) ( 221 = 5 ) ( 55 = 5 ) ( 134 = 5 ) ( 243 = 5 ) ( 14 = 5 ) ( 202 = 5 ) ( 120 = 5 ) ( 273 = 0 ) ( 294 = 0 ) ( 256 = 0 ) ( 313 = 0 ) ( 234 = 0 ) ( 162 = 0 ) ( 350 = 0 ) ( 198 = 0 ) ( 58 = 0 ) ( 43 = 0 ) ( 271 = 0 ) ( 4 = 0 ) ( 253 = 0 ) ( 85 = 0 ) ( 339 = 0 ) ( 40 = 0 ) ( 140 = 0 ) ( 37 = 0 ) ( 154 = 0 ) ( 225 = 0 ) ( 15 = 0 ) ( 123 = 0 ) ( 95 = 0 ) ( 178 = 0 ) ( 177 = 0 ) ( 332 = 0 ) ( 62 = 0 ) ( 159 = 0 ) ( 28 = 0 ) ( 84 = 0 ) ( 115 = 0 ) ( 317 = 0 ) ( 25 = 0 ) ( 314 = 0 ) ( 121 = 0 ) ( 65 = 0 ) ( 26 = 0 ) ( 239 = 0 ) ( 222 = 0 ) ( 5 = 0 ) ( 331 = 0 ) ( 327 = 0 ) ( 349 = 0 ) ( 166 = 0 ) ( 145 = 0 ) ( 18 = 0 ) ( 308 = 0 ) ( 29 = 0 ) ( 269 = 0 ) ( 334 = 0 ) ELSE 999 RANGE 0 : 5 VARLABEL "Tamaño de la ciudad (anterior)" VALUELABELS 0 " Otro " 1 " 1 MILLON O MAS " 2 " 500.000-999.999 " 3 " 100.000-499.999 " 4 " 50.000-99.999 " 5 " 20.000-49.999 " SAVE "TAMANORES5" OVERWRITE TABLE MB AS FREQUENCY OF PERSONA.TAMANORES by PERSONA.TAMANORES5 FOR PERSONA.EDAD > 4 AND PERSONA.EDAD < 999 OUTPUTFILE XLS "C:\ILPES\Mexico\redatam\2010\MIALC\VERSION 2020\SALIDAS\mex-2020-CTMB.xlsx" DEFINE PERSONA.CONDVIVIA AS SWITCH INCASE PERSONA.TAMANORES = PERSONA.TAMANORES5 ASSIGN 1 INCASE PERSONA.TAMANORES <> PERSONA.TAMANORES5 ASSIGN 2 RANGE 1 - 2 TABLE HABIT FREQ PERSONA.TAMANORES FOR PERSONA.TAMANORES5 >= 0 AND PERSONA.EDAD > 4 AND PERSONA.EDAD < 999 TABLE VIVIA FREQ PERSONA.TAMANORES5 FILTER PERSONA.EDAD > 4 and PERSONA.EDAD < 199 TABLE NOMIGRA FREQ PERSONA.TAMANORES FILTER PERSONA.CONDVIVIA = 1 AND PERSONA.EDAD > 4 AND PERSONA.EDAD < 999 //Inmigrantes TABLE Inmigrantes AS TABOP HABIT-NOMIGRA DECIMALS 0 //Emigrantes TABLE Emigrantes AS TABOP VIVIA-NOMIGRA DECIMALS 0 //MigraciA3n Neta TABLE Migra_Neta AS TABOP OF Inmigrantes - Emigrantes DECIMALS 0 //MigraciA3-Brutan Bruta TABLE Migra_Bruta AS TABOP Inmigrantes + Emigrantes //InmigraciA3n TABLE Inmigracion AS TABOP ((Inmigrantes /5) / ((HABIT + VIVIA)/2)* 1000) //EmigraciA3n TABLE Emigracion AS TABOP ((Emigrantes /5) / ((HABIT + VIVIA)/2)*1000) //MigracA3n Neta TABLE Ind_Migra_Neta AS TABOP Inmigracion - Emigracion //indice de eficacia migratoria TABLE Ind_Efi_Migr TABOP Migra_Neta / Migra_Bruta TABLE INDICADORES TABLELIST HABIT, VIVIA, NOMIGRA, Inmigrantes, Emigrantes, Migra_Neta, Migra_Bruta, Inmigracion, Emigracion , Ind_Migra_Neta, Ind_Efi_Migr OUTPUTFILE XLS "C:\ILPES\Mexico\redatam\2010\MIALC\VERSION 2020\SALIDAS\mex-2020-CTMB.xlsx" APPEND