DEFINE PERSONA.SLABORAL
AS RECODE  PERSONA.P47BOCUPAC
( 1 : 2 = 1)(3 : 4=2)(5 : 9 =3)
RANGE (1 : 3 )
VARLABEL "Situación laboral"
Valuelabels
1 "Ocupado"
2 "Desocupado"
3 "No PEA"

TABLE DESEMPLEADO
AS FREQ OF MPIO.RES_HAB BY PERSONA.RES_REC
FILTER PERSONA.EDAD>=5 AND (PERSONA.P30B1VIVIA=2 OR PERSONA.P30B1VIVIA=3)
AND PERSONA.SLABORAL=2

TABLE PEA
AS FREQ OF MPIO.RES_HAB BY PERSONA.RES_REC
FILTER PERSONA.EDAD>=5 AND (PERSONA.P30B1VIVIA=2 OR PERSONA.P30B1VIVIA=3)
AND PERSONA.SLABORAL<=2

TABLE COLOMBIA2005
AS TABOP
OF DESEMPLEADO / PEA 

OUTPUTFILE XLS "C005C5TD.xlsx" OVERWRITE