*** Unemployment and economic inactivity syntax file
*** This command gets the 3% individual SARs with
*** a total sample of 1,843,525

GET
  FILE='C:\Program Files\SPSS12\SARS 2001\indiv2001.sav'.


*** This command makes the output look more polished 
*** as values and variable names are not included

SET OVars Labels ONumbers Labels TVars Labels TNumbers Labels.

crosstabs tables=econact by sex
 /cel = col cou.

recode econact (1 2 3 4 5 6=1) (7 8=2) (9 12 =3) (10=4) (11 13=5) into econ2.
Variable labels econ2 'Economic position (recoded)'.
Value labels econ2 1 'In paid work'  2' Unemployed' 3 'Sick/Retired'
 4 'Student' 5 'Other inactive'.
EXECUTE.

crosstabs tables=econ2 by sex
 /cel = col cou.

*** students are coded as either economically active
*** or economically inactive according to their 
*** secondary economic status


*** Recode age into age groups

recode age0 (16 20=1) (25=2) (30=3) (45=4) (60=5)
 (65 thru hi=6) into agegp.

Variable labels agegp 'Age group'.
Value labels agegp 1 '16 to 24' 2 '25 to 29' 3 '30-44' 4 '45-59' 5 '60-64' 6 '65+'.

**** Look at employment status disaggregated by age and sex

temporary.
select if sex=1.
crosstabs tables=econ2 by agegp
 /cel=col cou.

temporary.
select if sex=2.
crosstabs tables=econ2 by agegp
 /cel=col cou.


*** Extension exercise
*** Create a new variable to indicate whether an individual is economically active
*** or not.

*** this command provides the values as well as value labels in the tables

SET OVars Both ONumbers Labels TVars Both TNumbers Both.

***Generate nssec8

FREQUENCIES
  VARIABLES=nssec
  /ORDER=  ANALYSIS .

RECODE
  nssec
 (Lowest thru 6=1)   (7 thru 12=2)  (13 thru 16=3)  (17 thru 20=4)  (21 thru 23=5)
  (24 thru 30=6)  (31 thru 35=7)   (36 thru Highest=8)  (-9=SYSMIS) INTO
   nssec8 .
VARIABLE LABELS nssec8 'NS-SEC 8 analytical classes'.
EXECUTE .

Variable labels nssec8 'NS-SEC 8 analytical classes'.
Value labels nssec8 
1 'Higher managerial and professional occupations' 
2 'Lower managerial and professional occupations' 3 'Intermediate occupations' 
4 'Small Employers and Own account workers' 
5 'Lower supervisory and technical occupations' 
6 'Semi-routine occupations'
7'Routine occupationslab var nssec8'
8 'Never worked and long-term unemployed'.

frequencies vars econact nssec8.

CROSSTABS
  /TABLES=econact  BY nssec8
  /FORMAT= AVALUE TABLES
  /CELLS= col cou.


if econact le 6 ecact=1.
if econact ge 9 ecact=2.
if econact = 10 ecact=2.
if econact = 10 and nssec8 le 6 ecact=1.

Variable labels ecact 'Economically Active?'.
Value Labels ecact 1 'yes' 2 'No'.

*** checking the construction of the variable

Crosstabs tables econact by ecact.

Temporary.
select if econact=10.
Crosstabs tables=nssec8 by ecact
 /cel=col cou.


*** Analysing economic activity by age group and sex

temporary.
select if sex=1.
crosstabs tables=ecact by agegp
 /cel=col cou.

temporary.
select if sex=2.
crosstabs tables=ecact by agegp
 /cel=col cou.

********************************************************