DEFINE VIVIENDA.NUMJEFE
AS COUNT PERSONA
FOR PERSONA.PARENT=1
RANGE 0 - 9
TYPE INTEGER

DEFINE VIVIENDA.NUMCONY
AS COUNT PERSONA
FOR PERSONA.PARENT=2
RANGE 0 - 9
TYPE INTEGER

DEFINE VIVIENDA.JIND
AS COUNT PERSONA 
FOR PERSONA.PARENT=1 AND PERSONA.PERENT=1 
TYPE INTEGER
RANGE 0 - 9     
VARLABEL "Viv Jefe Indig"     

DEFINE VIVIENDA.JNOINDI
AS COUNT PERSONA
FOR PERSONA.PARENT=1 AND PERSONA.PERENT=3 
TYPE INTEGER
RANGE 0 - 9     
VARLABEL "Viv Jefe No Indig"     

DEFINE VIVIENDA.JNOESP
AS COUNT PERSONA
FOR PERSONA.PARENT=1 AND PERSONA.PERENT=9 
TYPE INTEGER
RANGE 0 - 9    
VARLABEL "Viv Jefe No Esp"                     

DEFINE VIVIENDA.CIND
AS COUNT  PERSONA
FOR PERSONA.PARENT=2 AND PERSONA.PERENT=1 
TYPE INTEGER
RANGE 0 - 9   
VARLABEL "Viv Conyuge Indig"      

DEFINE VIVIENDA.CNOINDI
AS COUNT  PERSONA
FOR PERSONA.PARENT=2 AND PERSONA.PERENT=3
TYPE INTEGER
RANGE 0 - 9   
VARLABEL "Viv Conyuge No Indig"      

DEFINE VIVIENDA.CNOESP
AS COUNT  PERSONA
FOR PERSONA.PARENT=2 AND PERSONA.PERENT=9 
TYPE INTEGER
RANGE 0 - 9   
VARLABEL "Viv Conyuge No especific"      

DEFINE VIVIENDA.INDIG
AS SWITCH 
INCASE VIVIENDA.JIND>0  AND VIVIENDA.NUMCONY>=0
ASSIGN 1
INCASE VIVIENDA.CIND>0  AND VIVIENDA.NUMJEFE>=0
ASSIGN 1
INCASE VIVIENDA.JNOINDI>0 AND VIVIENDA.CNOINDI>0
ASSIGN 3
INCASE VIVIENDA.JNOINDI>0 AND VIVIENDA.CNOESP>0
ASSIGN 3
INCASE VIVIENDA.JNOESP>0 AND VIVIENDA.CNOINDI>0
ASSIGN 3
INCASE VIVIENDA.JNOESP>0 AND VIVIENDA.CNOESP>0
ASSIGN 9
INCASE VIVIENDA.JNOINDI>0 AND VIVIENDA.NUMCONY=0
ASSIGN 3
INCASE VIVIENDA.JNOESP>0 AND VIVIENDA.NUMCONY=0
ASSIGN 9
ELSE 10
TYPE INTEGER
RANGE 0 - 10    
VARLABEL "Condicion Viv Indig"   
VALUELABELS
           1 "VIV INDIGENAS"
           3 "VIV RESTO" 
           9 "VIV No especificada"   

DEFINE PERSONA.INDIGENA
AS SWITCH
INCASE PERSONA.EDAD>=3 
ASSIGN PERSONA.PERENT
INCASE PERSONA.EDAD< 3
ASSIGN VIVIENDA.INDIG
ELSE 9
TYPE INTEGER
RANGE 0 - 9    
VARLABEL "Condicion pers Indig"   
VALUELABELS
           1 "INDIGENAS"
           3 "RESTO" 
           9 "No especificada" 

DEFINE PERSONA.IND
AS RECODE PERSONA.INDIGENA
(1=1)
(3=2)
DEFAULT 0
TYPE INTEGER
RANGE 1 - 2
VARLABEL "Condicion Indigena"
VALUELABELS
1 "Indigenas"
2 "No Indigenas" 

TABLE IN 
AS CROSSTABS
OF PERSONA.ciudadres
BY PERSONA.IND
BY PERSONA.ciudadres5
FOR PERSONA.EDAD>4 AND PERSONA.EDAD<999 
WEIGHT VIVIENDA.FACTOR

 OUTPUTFILE XLS "C:\ILPES\Mexico\redatam\2010\MIALC\VERSION 2020\SALIDAS\mex-2010-C5IN.xlsx"