* Encoding: UTF-8.
VALUE LABELS REG '1'	'Bangkok'  '2'	 'Central'  '3'	 'North'  '4' 	'Northeast'  '5' 	'South'.
VALUE LABELS AREA '1'	'Urban' '2'	'Rural'.

VALUE LABELS A4 '1'	'Male' '2'	'Female'.

VALUE LABELS A9 
'1'	'Single'
'2'	'Married and live in the same house'
'3'	'Married but do not live together'
'4'	'Widow'
'5'	'Divorce'
'6'	'Separate'
'7'	'Married but do not know current status'
'9'	'Dont know'.

VALUE LABELS F6 
'1'	'Employed'
'2'	'Seasonal unemployed'
'3'	'Do not have job'
'9'	'Dont know'.
VALUE LABELS F8 
'1'	'Employer'
'2'	'Self employed, not employee'
'3'	'Family worker, no paid'
'4'	'Government employee'
'5'	'State enterprise employee'
'6'	'Private employee'
'7'	'Member of group producer'
'9'	'Dont know'.

VALUE LABELS F11 
'1'	'Want to work and looking for work'
'2'	'Want to work, but not looking for work'
'3'	'Dont want to work'
'9'	'Dont know'.

VALUE LABELS F23 
'1'	'No income'
'2'	'Income from work'
'3'	'Pension'
'4'	'Social Security fund'
'5'	'Old age supplement income'
'6'	'Income from asset or saving'
'7'	'Income from spouse'
'8'	'Income from children'
'9'	'Income from parent'
'10'	'Income from relative'
'11'	'Others'
'99'	'Dont know'.

VALUE LABELS F24 
'1'	'No income'
'2'	'< 10,000 B'
'3'	'10,000 - 19,999 B'
'4'	'20,000 - 29,999 B'
'5'	'30,000 - 39,000 B'
'6'	'40,000 - 49,999 B'
'7'	'50,000 - 59,999 B'
'8'	'60,000 - 69,000 B'
'9'	'70,000 - 79,999 B'
'10'	'80,000 - 89,999 B'
'11'	'100,000 - 299,999 B'
'12'	'300,000 - 499,999 B'
'13'	'> 500,000 B'
'99'	'Dont know'.

VALUE LABELS F28 
'1'	'Yourself or your spouse'
'2'	'Parents'
'3'	'Children'
'4'	'Son / daughter-in-law'
'5'	'Grand children'
'6'	'Relatives'
'7'	'Others'
'9'	'Dont know'.

VALUE LABELS F46 
'1'	'0'
'2'	'< 1,000 B'
'3'	'1,000 - 4,999 B'
'4'	'5,000 - 9,999 B'
'5'	'10,000 - 29,999 B'
'6'	'30,000 - 49,999 B'
'7'	'> 50,000 B'
'8'	'Dont have children'
'9'	'Dont know'.

VALUE LABELS F47 
'1'	'0'
'2'	'< 1,000 B'
'3'	'1,000 - 4,999 B'
'4'	'5,000 - 9,999 B'
'5'	'10,000 - 29,999 B'
'6'	'30,000 - 49,999 B'
'7'	'> 50,000 B'
'8'	'Dont have children'
'9'	'Dont know'.

VALUE LABELS F48 
'1'	'0'
'2'	'< 1,000 B'
'3'	'1,000 - 4,999 B'
'4'	'5,000 - 9,999 B'
'5'	'10,000 - 29,999 B'
'6'	'30,000 - 49,999 B'
'7'	'> 50,000 B'
'8'	'Dont have children'
'9'	'Dont know'.

VALUE LABELS F49 
'1'	'0'
'2'	'< 1,000 B'
'3'	'1,000 - 4,999 B'
'4'	'5,000 - 9,999 B'
'5'	'10,000 - 29,999 B'
'6'	'30,000 - 49,999 B'
'7'	'> 50,000 B'
'8'	'Dont have children'
'9'	'Dont know'.

TEMPORARY.
select if (f23=5).
FREQUENCIES VARIABLES=F24 
  /ORDER=ANALYSIS.

*************************EXERCISE.

*Q1. 
*Average age of the  elder who receive pension and old age income supplement from the government.


DATASET ACTIVATE $DataSet.
* Custom Tables.
CTABLES
  /VLABELS VARIABLES=F23 A5 DISPLAY=DEFAULT
  /TABLE F23 BY A5 [MEAN]
  /CATEGORIES VARIABLES=F23 ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=AFTER.
MEANS TABLES=A5 BY F23
  /CELLS=MEAN COUNT STDDEV.
TEMPORARY.
select if (f23=3).
DESCRIPTIVES VARIABLES=A5
  /STATISTICS=MEAN STDDEV MIN MAX.

TEMPORARY.
select if (f23=5).
DESCRIPTIVES VARIABLES=A5
  /STATISTICS=MEAN STDDEV MIN MAX.

*Q2.
*Home ownership by region.
CROSSTABS 
  /TABLES=F28 BY REG 
  /FORMAT=AVALUE TABLES 
  /STATISTICS=CHISQ 
  /CELLS=COUNT COLUMN 
  /COUNT ROUND CELL.
*Q3.
*Money received from children living far away by region.
CROSSTABS
  /TABLES=F48 BY REG
  /FORMAT=AVALUE TABLES
  /CELLS=COUNT COLUMN 
  /COUNT ROUND CELL.
TEMPORARY.
select if (F49>0 & F49<8).
FREQUENCIES VARIABLES=F8 
  /ORDER=ANALYSIS.

TEMPORARY.
select if (F49>0 & F49<8).
FREQUENCIES VARIABLES=F23 
  /ORDER=ANALYSIS.