DEFINE PERSONA.PEA
AS RECODE PERSONA.CONACT
(10 - 20=1)
(30=2)
ELSE 0
TYPE INTEGER
RANGE 1 - 2
VARLABEL "PEA"
VALUELABELS
1 "OCUPADO"
2 "DESOCUPADO"

TABLE POBLA
AS CROSSTABS
OF PERSONA.ciudadres
BY PERSONA.ciudadres5
FOR PERSONA.EDAD>11 AND PERSONA.EDAD<131 AND PERSONA.CONACT<99  
WEIGHT VIVIENDA.FACTOR

TABLE ENPEA
AS CROSSTABS
OF PERSONA.ciudadres
BY PERSONA.ciudadres5
FOR PERSONA.EDAD>11 AND PERSONA.EDAD<131 AND PERSONA.PEA>0 
WEIGHT VIVIENDA.FACTOR

TABLE PA 
AS MATRIXOP
OF ENPEA / POBLA
OUTPUTFILE XLS "C:\ILPES\Mexico\redatam\2010\MIALC\VERSION 2020\SALIDAS\mex-2010-C5PA.xlsx"