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

TABLE POBEDAD
AS CROSSTABS
OF Persona.ciudadres BY Persona.ciudadres5
FOR Persona.EDAD>11 AND Persona.EDAD<131 AND Persona.CONACT<99
 WEIGHT  VIVIENDA.FACTOR 
 
TABLE POBPEA
AS CROSSTABS
OF Persona.ciudadres BY Persona.ciudadres5
FOR Persona.EDAD>11 AND Persona.EDAD<131 AND Persona.PEA1 >0
WEIGHT  VIVIENDA.FACTOR  

TABLE MEXICO2000
AS MATRIXOP
OF POBPEA /  POBEDAD
OUTPUTFILE XLS "mex-2000-C5PA.xlsx"