DEFINE PERSONA.EDADQUIN AS RECODE PERSONA.PC09BEDAD (0 : 4 = 1) (5 : 9 = 2) (10 : 14 = 3) (15 : 19 = 4) (20 : 24 = 5) (25 : 29 = 6) (30 : 34 = 7) (35 : 39 = 8) (40 : 44 = 9) (45 : 49 = 10) (50 : 54 = 11) (55 : 59 = 12) (60 : 64 = 13) (65 : 69 = 14) (70 : 74 = 15) (75 : 79 = 16) (80 : 84 = 17) (85 : 89 = 18) (90 : 94 = 19) (95 : 99 = 20) (100 : 104 = 21) (105 : 109 = 22) (110 : 115 = 23) ELSE 25 TYPE INTEGER RANGE (1 : 23) VARLABEL "Grupos de edad quinquenal" VALUELABELS 1 " 0 - 4 " 2 " 5 - 9 " 3 " 10 - 14 " 4 " 15 - 19 " 5 " 20 - 24 " 6 " 25 - 29 " 7 " 30 - 34 " 8 " 35 - 39 " 9 " 40 - 44 " 10 " 45 - 49 " 11 " 50 - 54 " 12 " 55 - 59 " 13 " 60 - 64 " 14 " 65 - 69 " 15 " 70 - 74 " 16 " 75 - 79 " 17 " 80 - 84 " 18 " 85 - 89 " 19 " 90 - 94 " 20 " 95 - 99 " 21 " 100 - 104 " 22 " 105 - 109 " 23 " 110 + " MISSING 26 NOTAPPLICABLE 27 DEFINE PERSONA.CIUCONDICI AS SWITCH INCASE ( MPIO.RES_HAB <> PERSONA.RES_REC ) ASSIGN 1 INCASE ( PERSONA.RES_REC = PERSONA.RES_REC ) ASSIGN 0 TYPE INTEGER RANGE (0 : 1) VARLABEL "Condición de Migrante reciente por Ciudad" VALUELABELS 1 "Migrante" 0 "No Migrante" TABLE COLOMBIA2005 AS FREQ OF PERSONA.EDADQUIN BY PERSONA.CIUCONDICI FILTER PERSONA.EDAD>=5 AND (PERSONA.P30B1VIVIA=2 OR PERSONA.P30B1VIVIA=3) OUTPUTFILE XLS "C005C5DA.xlsx" OVERWRITE