*WERS 2004 MQ FF tables.sps .

*Tables syntax for the WERS 2004 Cross-Section Management survey.
*This file creates the tables and analysis contained in the First Findings publication.
*Last updated 31 July 2006.

*Before running this syntax, please ensure the file paths are changed throughout the file as necessary. 
*These can be found by searching on the phrase 'Note file path' .
*Please note that it is also necessary to change the file paths in the separate file 'WERS 2004 MQ derived variables for FF.sps' for this syntax to run successfully .

*User must first run 'WERS 2004 MQ derived variables for FF.sps'.

*Note file path .

include 'C:\WERS\WERS 2004 MQ derived variables for FF.sps'.

*********************.
* Additional notes .
*********************.
* The figures in First Findings for issues discussed at workforce meetings and team briefings mistakenly omitted the backcodes XDMWHIC1-3 and XDBWHIC1-3 .
* These backcodes are included in the syntax in this file .
* This syntax gives a figure of 5.9% of workplaces having at least ten employment tribunal claims brought against them .
* This compares with 5% reported in the text in First Findings (p. 23, Addressing workplace conflict). 
* However, more importantly, note that in First Findings the sentence which reports this should read “more than ten claims per thousand employees brought against them”.
* Note that for Table 6, 'Only other methods' is calculated as NREVNEGO2 + NOPAY2, 'Any other methods' is calculated as NPAYREVA + NPAYOTHA . 
* Unable to replicate 2004 figures for 'Only other methods' for the public sector & all workplaces; 'Pay Review Body' for all workplaces & 'Any other methods' for the private sector. 


*Apply weights.

WEIGHT BY estwtnr.

*********************.
*Introduction.
*********************.

*********************.
*About First Findings.
*********************.

***************************************************************.
*The design and conduct of the survey.
***************************************************************.

***************************************************************.
*Coverage.
***************************************************************.
** Figure 1 Distribution of workplaces and employment, by workplace size. 

*Distribution of workplaces by size.

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nempsiz7 + base1) 
	/statistics cpct(nempsiz7(f3) '') count(base1 'Weighted') u count(base1 'Unweighted') 
	/table (n25plus + base1) 
	/statistics cpct(n25plus(f3) '') count(base1 'Weighted') u count(base1 'Unweighted') .

*Distribution of employment by size.

weight by empwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nempsiz7 + base1) 
	/statistics cpct(nempsiz7(f3) '') count(base1 'Weighted') u count(base1 'Unweighted') 
	/table (n25plus + base1) 
	/statistics cpct(n25plus(f3) '') count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.

*Then select only those workplaces with 10 or more employees.

USE ALL.
FILTER BY filter_$.
EXECUTE .

***************************************************************.

***************************************************************.
*Survey structure.
***************************************************************.

*Location of MQ interview .

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (mqloc + base1) 
	/statistics cpct(mqloc(f3) '') count(base1 'Weighted') u count(base1 'Unweighted') .

*Proportion of workplaces where manager was a designated personnel specialist .

** Exclude temporarily those cases where interview not carried out on site.

temp.
select if mqlocx=1 .


* Specialists versus generalists .

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nperspec + base1) 
	/statistics cpct(nperspec(f3) '') count(base1 'Weighted') u count(base1 'Unweighted') .


***************************************************************.
*Survey content.
***************************************************************.

***************************************************************.
*Fieldwork outcomes.
***************************************************************.

***************************************************************.
*A profile of workplaces.
***************************************************************.
***************************************************************.
*Industry and sector of ownership.
***************************************************************.

** Table 1 Distribution of workplaces, by industry and sector of ownership (part 1).

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nsicode + base1) 
	/statistics cpct(nsicode(f3) '') count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nsicode + total1) by (nprivate + base1) 
	/statistics cpct(nprivate(f3) '':nsicode) count(base1 'Weighted') u count(base1 'Unweighted') 
	/table (nallest + nsector3 + base1) 
	/statistics cpct(nsector3(f3) '') count(base1 'Weighted') u count(base1 'Unweighted') .


***************************************************************.
*Location within larger organisations.
***************************************************************.

** Table 1 Distribution of workplaces, by industry and sector of ownership (part 2).

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + total1) by (nsingle+ base1) 
	/statistics cpct(nsingle(f3) '':nempsiz7) count(base1 'Weighted') u count(base1 'Unweighted') 
  	/table (nallest + nsicode + nprivate + total1) by (nsme2 + base1) 
	/statistics cpct(nsme2(f3) '':nsicode nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*The segmentation of employment.
***************************************************************.
***************************************************************.
*Younger and older employees.
***************************************************************.
** Figure 2 Workplace concentration of employees within specific age ranges.

*Average proportion of the workforce aged 16-21.
*For workplaces with 10 plus employees only.

weight by empwtnr.
temp.
select if n10plus=2.
TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL BASE1 'Base' total1 'All workplaces'
  /OBSERVATION n16t21
  /TABLES (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1)  BY  (n16t21)
  /STATISTICS mean((F5.0) 'Density %') validn((F5) 'Weighted') u validn ((F5) 'Unweighted') .

*Proportion of employees aged 16 to 21 - banded.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (n16t21d + base1) 
	/statistics cpct(n16t21d(f3) '': nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Average proportion of workforce aged 16 to 17.
*For workplaces with 10 plus employees only.

weight by empwtnr.
temp.
select if n10plus=2.
TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL BASE1 'Base' total1 'All workplaces'
  /OBSERVATION n16t17
  /TABLES (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1)  BY  (n16t17)
  /STATISTICS mean((F5.0) 'Density %') validn((F5) 'Weighted') u validn ((F5) 'Unweighted') .

*Proportion of the workforce aged 16-17.
*For workplaces with 10 plus employees only.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (n16t17d + base1) 
	/statistics cpct(n16t17d(f3) '': nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Average proportion of workforce aged 50 plus.
*For workplaces with 10 plus employees only.

weight by empwtnr.
temp.
select if n10plus=2.
TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL BASE1 'Base' total1 'All workplaces'
  /OBSERVATION n50plus
  /TABLES (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1)  BY  (n50plus)
  /STATISTICS mean((F5.0) 'Density %') validn((F5) 'Weighted') u validn ((F5) 'Unweighted') .

*Proportion of the workforce aged 50 plus - banded.
*For workplaces with 10 plus employees only.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (n50plusd + base1) 
	/statistics cpct(n50plusd(f3) '': nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*Gender segregation in management.
***************************************************************.
** Figure 3 Workplaces where women were under-represented in management, by industry.

*Proportion of workforce female.

weight by empwtnr.
temp.
select if n10plus=2.
TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL BASE1 'Base' total1 'All workplaces'
  /OBSERVATION nfemdens
  /TABLES (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1)  BY  (nfemdens)
  /STATISTICS mean((F5.0) 'Density %') validn((F5) 'Weighted') u validn ((F5) 'Unweighted') .

*Proportion of managers who are female.

weight by empwtnr.
temp.
select if n10plus=2.
TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL BASE1 'Base' total1 'All workplaces'
  /OBSERVATION nmgtgen
  /TABLES (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1)  BY  (nmgtgen)
  /STATISTICS mean((F5.0) 'Density %') validn((F5) 'Weighted') u validn ((F5) 'Unweighted') .

*Workplaces where women were under-represented in management.
*By standard breaks.
*Workplaces with 10 or more employees.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nfmgt2 + base1) 
	/statistics cpct(nfmgt2(f3) '': nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Workplaces where men were under-represented in management.
*By standard breaks.
*Workplaces with 10 or more employees.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nmmgt2 + base1) 
	/statistics cpct(nmmgt2(f3) '': nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*Numerical flexibility.
***************************************************************.
*Incidence of part-time employment.
*For workplaces with 10 plus employees only.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nptprop + base1) 
	/statistics cpct(nptprop(f3) '': nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Proportion of workplaces with only female part-time workers (from workplaces with some part-time workers).

temp.
select if n10plus=2 & npartwom<2.
WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (npartwom + base1) 
	/statistics cpct(npartwom(f3) '': nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Proportion of workplaces with any employees on temporary or fixed-term contracts.
*For workplaces with 10 plus employees only.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nfixterm + base1) 
	/statistics cpct(nfixterm(f3) '': nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Proportion of workplaces with any temporary agency workers by standard breaks.
*For workplaces with 10 plus employees only.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (ntempany + base1) 
	/statistics cpct(ntempany(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*Recruitment, appraisal and training.
***************************************************************.
*Approach to filling vacancies, preference for internal or external applicants.

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nprivate + total1) by (nvacpref + base1) 
	/statistics cpct(nvacpref(f3) '':nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .

** Table 2 Selection tests, performance appraisals and off-the-job training, by sector of ownership, 1998 and 2004.

*Use of personality tests in recruitment .

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nprivate + total1) by (nperstest + base1) 
	/statistics cpct(nperstest(f3) '':nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .

*Routine use of personality tests.

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nprivate + total1) by (nperslog + base1) 
	/statistics cpct(nperslog(f3) '':nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .


*Types of applicant routinely given a personality test.

weight by estwtnr .
fre npsontst .


*Personality tests routinely used for applicants to the largest occupational group .

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nperstest + total1) by (nperslog + base1) 
	/statistics cpct(nperslog(f3) '':nperstest) count(base1 'Weighted') u count(base1 'Unweighted') .

*Routine use of performance tests.

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nprivate + total1) by (nperflog + base1) 
	/statistics cpct(nperflog(f3) '':nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .

*Performance appraisals.

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nprivate + total1) by (napprais + base1) 
	/statistics cpct(napprais(f3) '':nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .


*Proportion of non-managerial employees who are appraised.

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nprivate + total1) by (nmappra1 + base1) 
	/statistics cpct(nmappra1(f3) '':nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .

*Off-the-job training.

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nprivate + total1) by (ntrain + base1) 
	/statistics cpct(ntrain(f3) '':nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .

*Duration of training .

fre nltrain .

***************************************************************.
*Work organisation.
***************************************************************.
** Table 3 Work organisation, by sector of ownership, 1998 and 2004.

* Team-working: Incidence .
WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (nteams+ base1) 
	/statistics cpct(nteams(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .


* Team-working: Embeddedness .

WEIGHT by estwtnr.
temp .
select if nteams<7 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (nteamsb+ base1) 
	/statistics cpct(nteamsb(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .
	
* Team-working: Autonomy .
WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (cteamhoa+ base1) 
	/statistics cpct(cteamhoa(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (cteamhoe+ base1) 
	/statistics cpct(cteamhoe(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (cteamhob+ base1) 
	/statistics cpct(cteamhob(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (cteamhoc+ base1) 
	/statistics cpct(cteamhoc(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (cteamhod+ base1) 
	/statistics cpct(cteamhod(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .


*Cross-training .

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + nhiocc + total1) by (nothjob+ base1) 
	/statistics cpct(nothjob(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3 nhiocc) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + nhiocc + total1) by (nfunc+ base1) 
	/statistics cpct(nfunc(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3 nhiocc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Functional flexibility in practice.

WEIGHT by estwtnr.
temp .
select if cothjob<7 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + nhiocc + total1) by (nothdo + base1) 
	/statistics cpct(nothdo(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3 nhiocc) count(base1 'Weighted') u count(base1 'Unweighted') .


* Incidence of problem-solving groups .

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (npsolve2+ base1) 
	/statistics cpct(npsolve2(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (npropor + base1) 
	/statistics cpct(npropor(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .


* Training in teamworking, communication or problem-solving skills. 

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + xrecog1 + xrecog3 + total1) by (ntrgrup1b+ base1) 
	/statistics cpct(ntrgrup1b(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode xrecog1 xrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + ntrgrup1b + total1) by any3
	/statistics cpct(ntrgrup1b(f3) '': any3) count(total1 'Weighted') u count(total1 'Unweighted')  .


***************************************************************.
*Representation, consultation and communication.
***************************************************************.

***************************************************************.
*Union membership density.
***************************************************************.

** Table 4 Union presence, by sector of ownership and management attitudes.

*For columns 2 & 3 .

WEIGHT by estwtnr.
temp .
select if ndens3<7 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews + total1) by (ndens3 + base1) 
	/statistics cpct(ndens3(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews) count(base1 'Weighted') u count(base1 'Unweighted') .


***************************************************************.
*Representative voice.
***************************************************************.
*Whether any union members present .

WEIGHT by estwtnr.
freq vars=nanymem .

*Proportion of workplaces recognising one or more unions .

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (xrecog1 + base1) 
	/statistics cpct(xrecog1(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .

*Proportion of employees in workplaces recognising one or more unions .

WEIGHT by empwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (xrecog1 + base1) 
	/statistics cpct(xrecog1(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .

*Of workplaces with union members, proportion recognising one or more unions .

temp .
select if nanymem=1 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (xrecog1 + base1) 
	/statistics cpct(xrecog1(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .

*Recognised unions - proportion of workplaces (Table 4, final column) .

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (xrecog3 + base1) 
	/statistics cpct(xrecog3(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .

WEIGHT by empwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (xrecog3 + base1) 
	/statistics cpct(xrecog3(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .

*Proportion of workplaces with recognised unions in which members had access to lay representative .

WEIGHT by estwtnr.
temp .
select if xrecog1=2 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (nerep + base1) 
	/statistics cpct(nerep(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .


*Whether access to lay representative at own workplace .

WEIGHT by estwtnr.
temp .
select if xrecog1=2 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (esteward + base1) 
	/statistics cpct(esteward(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .


* Presence of on-site union reps.

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsize + nprivate + total1) by (nanyurep2 + base1) 
	/statistics cpct(nanyurep2(f3) '':nempsize nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .

WEIGHT by empwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsize + nprivate + total1) by (nanyurep2 + base1) 
	/statistics cpct(nanyurep2(f3) '':nempsize nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .


* Joint consultative committees.

*Presence of workplace JCC, presence of consultative committees at workplace or higher level.

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (njcc + base1) 
	/statistics cpct(njcc(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (nanycom2 + base1) 
	/statistics cpct(nanycom2(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .

weight by empwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (njcc + base1) 
	/statistics cpct(njcc(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .

*Frequency of meeting for multi-issue JCCs.

WEIGHT by estwtnr.
temp .
select if njcc=3 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (ndmeet2 + base1) 
	/statistics cpct(ndmeet2(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .


* Issues discussed by multi-issue JCCs.

WEIGHT by estwtnr.
temp .
select if njcc=3 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/mrgroup=discuss "Issues discussed by multi-issue JCC" d1whi01 to xd1whi3
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (discuss + base1) 
	/statistics cpct(discuss(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (discuss + base1) by njccu
	/statistics cpct(discuss(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews njccu) count(base1 'Weighted') u count(base1 'Unweighted') .


WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + eviews+ total1) by (nnureptyp2 + base1) 
	/statistics cpct(nnureptyp2(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode eviews ) count(base1 'Weighted') u count(base1 'Unweighted') .

* Correlation with unionism. 

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nanymem + nrecog3 + nanymem>nreptyp2 + total1) by (nnureptyp + base1) 
	/statistics cpct(nnureptyp(f3) '':nanymem nrecog3 nreptyp2) count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*The roles and activities of employee representatives.
***************************************************************.
** Figure 4 Extent of trust between managers and employee representatives.

* Union Learning Reps. 

* Incidence from MQ .

WEIGHT by urwt.
temp .
select if value(nulrpc)~=-7 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/observation=nulrpc
 	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + total1) by (nulrpc + base1) 
	/statistics mean(nulrpc(f3.1) '') count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*Direct communication.
***************************************************************.
** Table 5 Direct communication and information sharing, by sector of ownership, 1998 and 2004.

* All components by private and public sector split .

WEIGHT by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nmeet + dinvplan + dfinance + dwholefi + dstaffin + base1) by (nprivate + total1) 
	/statistics cpct(nmeet(f3) '':nprivate) cpct(dinvplan(f3) '':nprivate) cpct(dfinance(f3) '':nprivate) cpct(dwholefi(f3) '':nprivate) cpct(dstaffin(f3) '':nprivate)  
	count(base1 'Weighted') u count(base1 'Unweighted') .

temp.
sel if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/mrgroup=dconsult 'Ways management communicate' DCONSUL1 to XDCONSU3
	/table (dconsult + base1) by (nprivate+total1)
	/statistics cpct(dconsult(f3) '': nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .

*Employee surveys by sector break.

WEIGHT by estwtnr.
temp.
sel if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (dsurvey + base1) by (nprivate+total1)
	/statistics cpct(dsurvey(f3) '': nprivate) count(base1 'Weighted') u count(base1 'Unweighted').

* Issues discussed at workplace meetings.
* Note that the figures in First Findings mistakenly omit the backcodes XDMWHIC1 to XDMWHIC3, these are included here .

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/mrgroup=discussm 'Issues discussed at regular workforce meetings' dmwhic01 to XDMWHIC3
	/table (discussm + base1) by nallest
	/statistics cpct(discussm(f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

* Issues discussed at team briefings .
* Note that the figures in First Findings mistakenly omit the backcodes XDBWHIC1 to XDBWHIC3, these are included here .

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/mrgroup=discussb 'Issues discussed at team briefings' dbwhic01 to XDBWHIC3
	/table (discussb + base1) by nallest
	/statistics cpct(discussb(f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

*Time allowed during team meetings and workplace briefings for feedback from employees .

fre dmtwoway dbtwoway .

*Whether formal survey of employees and whether results made available in written form to employees .

fre dsurvey dresults .

***************************************************************.
*Reward and remuneration.
***************************************************************.

***************************************************************.
*Methods of pay determination.
***************************************************************.

* Incidence of collective bargaining by workplace characteristics .

weight by estwtnr .

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/observation nfcovdum
	/autolabel=on
	/table (nallest + nempsiz1 + n25pluso + norgsize + nsme1  + nprivate + nsingle + nsector3 + nsicode + xrecog3 + xrecog1 + total1)
	 by (nfcovdum + base1) 
	/statistics mean((f4.3)) validn(base1 'Weighted') u validn(base1 'Unweighted') .


* Table 6 Pay determination methods, 1998 and 2004.
* Variety of pay determination methods used at workplace, by sector .
* Note that for Table 6, 'Only other methods' is calculated as NREVNEGO2 + NOPAY2, 'Any other methods' is calculated as NPAYREVA + NPAYOTHA . 
* Unable to replicate 2004 figures for 'Only other methods' for the public sector & all workplaces; 'Pay Review Body' for all workplaces & 'Any other methods' for the private sector. 

WEIGHT by estwtnr.
tables
  /format blank missing('.')
  /ftotal base1 'Base' total1 'All workplaces'
  /tables (Npaydet2 + total1 + Nbarg92 + Nanycb2 + Nsetman2 + Nindnego2 + Nrevnego2 + Nopay2)
  by (nallest + norgsize + nsme1  + nprivate + nsector3 + total1)
  /statistics cpct( (F5.0) 'Col %':nallest norgsize nsme1  nprivate nsector3) count(total1 'Weighted') u count(total1 'Unweighted') .

* The following syntax replicates the figures for the final paragraph of this section .
* Note that it is necessary to sum across the first three columns to obtain the percentage of employees whose pay is set by collective bargaining .
* Likewise, sum across the fourth and fifth column to obtain the percentage of employees whose pay is set by management .

WEIGHT by empwtnr.
tables
  /format blank missing('.')
  /ftotal base1 'Base' total1 'All workplaces'
  /observation ncbmulta ncborga ncbworka nsetorga nsetworka nindnega npayreva npayotha
  /tables (nallest + n10pluso + n25pluso + nempsize + norgsize + nsme1 + nsector3 + nprivate + nsingle + nsicode + xrecog3 + xrecog1 + total1)
  by  (ncbmulta + ncborga + ncbworka + nsetorga + nsetworka + nindnega + npayreva + npayotha + base1)
  /statistics mean((F5.0)) validn(base1 'Weighted') u validn(base1 'Unweighted') .

***************************************************************.
*Variable payment systems.
***************************************************************.

*Performance-related pay .

weight by estwtnr.
fre nanymerpbr .

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nempsize + nsingle + nprivate + xrecog1 + total1) by (fprof + base1) 
	/statistics cpct(fprof(f3) '':nempsize nsingle nprivate xrecog1) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nempsize + nsingle + nprivate + xrecog1 + total1) by (fperf1 + base1) 
	/statistics cpct(fperf1(f3) '':nempsize nsingle nprivate xrecog1) count(base1 'Weighted') u count(base1 'Unweighted') .


*Proportion of workplaces operating employee share ownership scheme.

weight by estwtnr .
fre Nesop.

***************************************************************.
*Non-pecuniary rewards.
***************************************************************.
* Entitlement to non-pecuniary rewards for managers and largest occupational group.
 
fre nlognone nlogpen nlogcar nloghlth nloghols nlogsick nmansick nmanhols nmanhlth nmancar nmannone nmanpen nss2 nss3 .

*Whether managers and other employees have equal conditions.

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nprivate + total1) by (nss3 + base1) 
	/statistics cpct(nss3(f3) '':nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .


***************************************************************.
*Joint regulation of terms and conditions.
***************************************************************.
** Table 7 Joint regulation of terms and conditions.

*All workplaces .

fre npay nhours nhol npen nselect ntrainab ngriev ndiscip nstaff nequalop Nhands nperfor .


*Workplaces with a recognised union .

temp.
select if xrecog3=2.
fre npay nhours nhol npen nselect ntrainab ngriev ndiscip nstaff nequalop Nhands nperfor .

*Management did not engage on any of the twelve listed items .

fre nnowt .

weight by estwtnr.

*Average number of items (out of a possible maximum twelve) on which management negotiated, consulted or informed employees .
*For workplaces with and without a recognised union .

means tables=nnegs ncons ninfs nnowt by xrecog3.



***************************************************************.
*Addressing workplace conflict.
***************************************************************.

* Incidence of collective disputes .

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (gdispute + base1) by nallest
	/statistics cpct(gdispute(f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .


* Incidence of industrial action in the last 12 months .

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (nstrike + base1) by nallest
	/statistics cpct(nstrike(f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .


*Proportion of workplaces with threatened industrial action in the last 12 months .

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (Nthretsk + base1) by nallest
	/statistics cpct(Nthretsk(f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

* Incidence of employment tribunal claims brought in the last 12 months .

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (nitclaim + base1) by nallest
	/statistics cpct(nitclaim (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

*Banded ET rate variable .
* This syntax gives a figure of 5.9% of workplaces having at least ten employment tribunal claims brought against them .
* This compares with 5% reported in the text in First Findings (p. 23, Addressing workplace conflict). 
* However, more importantly, note that in First Findings the sentence which reports this should read "more than ten claims per thousand employees brought against them".

weight by estwtnr .
tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (itrateband + base1) by nallest
	/statistics cpct(itrateband (f3.1) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

* Use of grievance procedure .

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (hraised + base1) by nallest
	/statistics cpct(hraised (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .



***************************************************************.
*Grievance and disciplinary procedures.
***************************************************************.

weight by estwtnr .

* Incidence of formal procedures for grievances .

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (hprocedu + base1) by nallest
	/statistics cpct(hprocedu (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

*Formal grievance procedures by standard workplace breaks .

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + norgsize + norgsize2 + nsme1 + nprivate + nsingle + nsicode + nrecog3 + nrecog2b + total1) by (hprocedu+ base1) 
	/statistics cpct(hprocedu (f3) '':nempsiz7 n25pluso norgsize norgsize2 nsme1 nprivate nsingle nsicode nrecog3 nrecog2b) count(base1 'Weighted') u count(base1 'Unweighted') .

* Incidence of disciplinary procedures .

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (hothpro + base1) by nallest
	/statistics cpct(hothpro (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

*Formal disciplinary procedures by standard workplace breaks .

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + norgsize + nsme1 + nprivate + nsingle + nsicode + nrecog3 + nrecog2b+ total1) by (hothpro+ base1) 
	/statistics cpct(hothpro (f3) '':nempsiz7 n25pluso norgsize nsme1 nprivate nsingle nsicode nrecog3 nrecog2b) count(base1 'Weighted') u count(base1 'Unweighted') .


** Figure 5 Procedures for handling grievances and disciplinary actions.

*Whether employee required to set out grievance in writing by formal procedure .

TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL = ftot1 'Base' ftot2 'All workplaces'
  /TABLES (hgrvwrte + ftot2)  BY (hprocedu + ftot1 )
  /STATISTICS cpct( ( PCT5.1) 'Column %':hprocedu)   count(ftot1 'W') u count(ftot1 'U') .

*Whether employee required to attend a formal meeting by formal grievance procedure .

TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL = ftot1 'Base' ftot2 'All workplaces'
  /TABLES (hgrvmtg + ftot2)  BY (hprocedu + ftot1 )
  /STATISTICS cpct( ( PCT5.1) 'Column %':hprocedu)   count(ftot1 'W') u count(ftot1 'U') .

*Whether employee has a right to appeal by formal grievance procedure .

TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL = ftot1 'Base' ftot2 'All workplaces'
  /TABLES (hgrvapl + ftot2)  BY (hprocedu + ftot1 )
  /STATISTICS cpct( ( PCT5.1) 'Column %':hprocedu)   count(ftot1 'W') u count(ftot1 'U') .

*Whether employer required to set out disciplinary matter in writing by incidence of formal procedure .

TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL = ftot1 'Base' ftot2 'All workplaces'
  /TABLES (hothwrt + ftot2)  BY (hothpro + ftot1 )
  /STATISTICS cpct( ( PCT5.1) 'Column %':hothpro)   count(ftot1 'W') u count(ftot1 'U') .

*Whether employee required to attend a formal meeting by formal disciplinary procedure .

TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL = ftot1 'Base' ftot2 'All workplaces'
  /TABLES (hothmtg + ftot2)  BY (hothpro + ftot1 )
  /STATISTICS cpct( ( PCT5.1) 'Column %':hothpro)   count(ftot1 'W') u count(ftot1 'U') .

*Whether employee has a right to appeal by formal disciplinary procedure .

TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL = ftot1 'Base' ftot2 'All workplaces'
  /TABLES (happeal + ftot2) bY (hothpro + ftot1 )
  /STATISTICS cpct( ( PCT5.1) 'Column %':hothpro)   count(ftot1 'W') u count(ftot1 'U') .

* Incidence of grievance procedure by presence of 3 step grievance procedure 

TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL = ftot1 'Base' ftot2 'All workplaces'
  /TABLES (ngproc3c + ftot2)  BY (hprocedu + ftot1 )
  /STATISTICS cpct( ( PCT5.1) 'Column %':hprocedu)   count(ftot1 'W') u count(ftot1 'U') .

*3 step grievance procedure by standard breaks .

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + norgsize + nsme1 + nprivate + nsingle + nsicode + nrecog3 + nrecog2b + total1) by (ngproc3c+ base1) 
	/statistics cpct(ngproc3c (f3) '':nempsiz7 n25pluso norgsize nsme1 nprivate nsingle nsicode nrecog3  nrecog2b) count(base1 'Weighted') u count(base1 'Unweighted').

* Incidence of 2 steps - meeting (always) and right to appeal .

TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL = ftot1 'Base' ftot2 'All workplaces'
  /TABLES (ngproc2 + ftot2)  BY (hprocedu + ftot1 )
  /STATISTICS cpct( ( PCT5.1) 'Column %':hprocedu)   count(ftot1 'W') u count(ftot1 'U').


* Incidence of three steps by presence of formal disciplinary procedure .

TABLES
  /FORMAT BLANK MISSING('.')
  /FTOTAL = ftot1 'Base' ftot2 'All workplaces'
  /TABLES (ndproc3c + ftot2)  BY (hothpro + ftot1 )
  /STATISTICS cpct( ( PCT5.1) 'Column %':hothpro)   count(ftot1 'W') u count(ftot1 'U') .

*Incidence of 3 step disciplinary procedure by standard workplace breaks.

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + norgsize + norgsize2 + nsme1 + nprivate + nsingle + nsicode + nrecog3 + nrecog2b + total1) by (ndproc3c + base1) 
	/statistics cpct(ndproc3c (f3) '':nempsiz7 n25pluso norgsize norgsize2 nsme1 nprivate nsingle nsicode nrecog3 nrecog2b) count(base1 'Weighted') u count(base1 'Unweighted') .



* Right to be accompanied in grievance meetings using summary variable (ngaccomp2) .

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ngaccomp2 + base1) by nallest
	/statistics cpct(ngaccomp2 (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

*Right to be accompanied in grievance meetings by key breaks .

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + norgsize + nsme1 + nprivate + nsingle + nsicode + nrecog3 + nrecog2b + total1) by (ngaccomp2+ base1) 
	/statistics cpct(ngaccomp2 (f3) '':nempsiz7 n25pluso norgsize nsme1 nprivate nsingle nsicode nrecog3  nrecog2b) count(base1 'Weighted') u count(base1 'Unweighted') .


*Accompaniment at disciplinary meetings .

* Right to be accompanied in disciplinary meetings using composite variable.

Weight by estwtnr.
tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndaccomp2 + base1) by nallest
	/statistics cpct(ndaccomp2 (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

* Right to be accompanied in disciplinary meetings by key breaks .

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + norgsize + nsme1 + nprivate + nsingle + nsicode + nrecog3 + nrecog2b + total1) by (ndaccomp2+ base1) 
	/statistics cpct(ndaccomp2 (f3) '':nempsiz7 n25pluso norgsize nsme1 nprivate nsingle nsicode nrecog3  nrecog2b) count(base1 'Weighted') u count(base1 'Unweighted') .


*What can the companion do at the grievance meeting .


*Whether the companion can ask questions at the grievance meeting.

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (hcomp1 + base1) by nallest
	/statistics cpct(hcomp1 (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether the companion can answer questions on the employees' behalf .

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (hcomp2 + base1) by nallest
	/statistics cpct(hcomp2 (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .


* What can the companion do at the disciplinary meeting .


*Whether the companion can ask questions at the disciplinary meeting.

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (hothcmp1 + base1) by nallest
	/statistics cpct(hothcmp1 (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .


*Whether the companion can answer questions on the employees' behalf .

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (hothcmp2 + base1) by nallest
	/statistics cpct(hothcmp2 (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .


***************************************************************.
*Collective disputes procedures.
***************************************************************.
* Incidence of formal procedures for dealing with any collective disputes raised by any group of non-managerial employees by standard breaks .

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + n25pluso + nempsize + norgsize + norgsize2 + nsme1 + nprivate + nsingle + nsicode + nrecog3 + nrecog2b + total1) by (gprocedu + base1) 
	/statistics cpct(gprocedu(f3) '': n25pluso nempsize norgsize norgsize2 nsme1 nprivate nsingle nsicode nrecog3 nrecog2b) count(base1 'Weighted') u count(base1 'Unweighted') .


* Presence of formal procedures for dealing with collective disputes raised by any group of non managerial employees .

weight by empwtnr .

weight by empwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + n25pluso + nempsize + norgsize + norgsize2 + nsme1 + nprivate + nsingle + nsicode + nrecog3 + nrecog2b + total1) by (gprocedu + base1) 
	/statistics cpct(gprocedu(f3) '': n25pluso nempsize norgsize norgsize2 nsme1 nprivate nsingle nsicode nrecog3 nrecog2b) count(base1 'Weighted') u count(base1 'Unweighted') .

* Issues covered by collective procedures .

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/mrgroup=gissues 'Changes' gissues1 to gissues5, xgissue1 to xgissue3
	/table (gissues + base1) by nallest
	/statistics cpct(gissues(f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .


***************************************************************.
*Equal opportunities policies and practices.
***************************************************************.
** Table 8 Equal opportunities practices, by presence of equal opportunities policy.

* Presence of equal opportunities policy.

weight by estwtnr .
tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (ipolicy + base1) by nallest
	/statistics cpct(ipolicy(f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .


*Formal EO policy by workplace breaks.

weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + n25pluso + nempsiz7 + norgsize  + nprivate + nsingle + nsicode + nrecog3 + total1) by (IPOLICY + base1) 
	/statistics cpct(ipolicy (f3) '':n25pluso nempsiz7 norgsize  nprivate nsingle nsicode nrecog3 ) count(base1 'Weighted') u count(base1 'Unweighted') .


* Excluding cases where managers reported that the policy did not explicitly mention equality of treatment or discrimination in respect of particular groups .

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nipolicy + base1) by nallest
	/statistics cpct(nipolicy(f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted').

*EO policy covering equality of treatment or discrimination by different workforce compositions .

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nf50 + nfpquart + nethbd + ndisbd2 + n16t21d2 + n50bd2+ total1) by (IPOLICY + base1) 
	/statistics cpct(ipolicy (f3) '':nf50 nfpquart nethbd ndisbd2  n16t21d2  n50bd2) count(base1 'Weighted') u count(base1 'Unweighted') .


*Coverage of policy - where the policy covered equality of treatment .

temp.
select if ipolicy = 1. 

weight by ESTWTNR .
tables 
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/mrgroup=igrounmr 'Coverage of eo policy' igroun01 to igroun10
	/table (igrounmr + base1) by nallest
	/statistics cpct(igrounmr(f3) '':nallest) count(base1 'Weighted') 
	u count(base1 'Unweighted') .


*Monitor recruitment and selection by gender.
*By standard breaks.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract11 + base1) 
	/statistics cpct(nipract11(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract11 + base1) 
	/statistics cpct(nipract11(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Monitor recruitment and selection by ethnicity.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract12 + base1) 
	/statistics cpct(nipract12(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract12 + base1) 
	/statistics cpct(nipract12(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Monitor recruitment and selection by disability.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract13 + base1) 
	/statistics cpct(nipract13(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract13 + base1) 
	/statistics cpct(nipract13(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Monitor recruitment and selection by age.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract14 + base1) 
	/statistics cpct(nipract14(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract14 + base1) 
	/statistics cpct(nipract14(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review recruitment and selection procedures to identify indirect discrimination.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract21 + base1) 
	/statistics cpct(nipract21(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract21 + base1) 
	/statistics cpct(nipract21(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review recruitment and selection procedures by ethnicity to identify indirect discrimination.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract22 + base1) 
	/statistics cpct(nipract22(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract22 + base1) 
	/statistics cpct(nipract22(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review recruitment and selection procedures by disability to identify indirect discrimination.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract23 + base1) 
	/statistics cpct(nipract23(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract23 + base1) 
	/statistics cpct(nipract23(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review recruitment and selection procedures by age to identify indirect discrimination.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract24 + base1) 
	/statistics cpct(nipract24(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract24 + base1) 
	/statistics cpct(nipract24(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Monitor promotions by gender.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract31 + base1) 
	/statistics cpct(nipract31(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract31 + base1) 
	/statistics cpct(nipract31(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Monitor promotions by ethnicity.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract32 + base1) 
	/statistics cpct(nipract32(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract32 + base1) 
	/statistics cpct(nipract32(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Monitor promotions by disability.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract33 + base1) 
	/statistics cpct(nipract33(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract33 + base1) 
	/statistics cpct(nipract33(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Monitor promotions by age.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract34 + base1) 
	/statistics cpct(nipract34(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract34 + base1) 
	/statistics cpct(nipract34(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review promotion procedures by gender to identify indirect discrimination.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract41 + base1) 
	/statistics cpct(nipract41(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract41 + base1) 
	/statistics cpct(nipract41(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review promotion procedures by ethnicity to identify indirect discrimination.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract42 + base1) 
	/statistics cpct(nipract42(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract42 + base1) 
	/statistics cpct(nipract42(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review promotion procedures by disability to identify indirect discrimination.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract43 + base1) 
	/statistics cpct(nipract43(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract43 + base1) 
	/statistics cpct(nipract43(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review promotion procedures by age to identify indirect discrimination.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract44 + base1) 
	/statistics cpct(nipract44(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract44 + base1) 
	/statistics cpct(nipract44(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review relative pay rates by gender.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract51 + base1) 
	/statistics cpct(nipract51(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract51 + base1) 
	/statistics cpct(nipract51(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review relative pay rates by ethnicity.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract52 + base1) 
	/statistics cpct(nipract52(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract52 + base1) 
	/statistics cpct(nipract52(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review relative pay rates by disability.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract53 + base1) 
	/statistics cpct(nipract53(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract53 + base1) 
	/statistics cpct(nipract53(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*Review relative pay rates by age.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nipract54 + base1) 
	/statistics cpct(nipract54(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By existence of written EO policy.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + total1) by (nipract54 + base1) 
	/statistics cpct(nipract54(f3) '':ipolicy) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition - more than half female.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nipract11 + base1) 
	/statistics cpct(nipract11(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition - more than half female.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nipract21 + base1) 
	/statistics cpct(nipract21(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition - more than half female.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nipract31 + base1) 
	/statistics cpct(nipract31(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition - more than half female.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nipract41 + base1) 
	/statistics cpct(nipract41(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition - more than half female.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nipract51 + base1) 
	/statistics cpct(nipract51(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*No ethnic minority employees.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethany + total1) by (nipract12 + base1) 
	/statistics cpct(nipract12(f3) '':nethany) count(base1 'Weighted') u count(base1 'Unweighted') .

*No ethnic minority employees.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethany + total1) by (nipract22 + base1) 
	/statistics cpct(nipract22(f3) '':nethany) count(base1 'Weighted') u count(base1 'Unweighted') .

*No ethnic minority employees.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethany + total1) by (nipract32 + base1) 
	/statistics cpct(nipract32(f3) '':nethany) count(base1 'Weighted') u count(base1 'Unweighted') .

*No ethnic minority employees.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethany + total1) by (nipract42 + base1) 
	/statistics cpct(nipract42(f3) '':nethany) count(base1 'Weighted') u count(base1 'Unweighted') .

*No ethnic minority employees.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethany + total1) by (nipract52 + base1) 
	/statistics cpct(nipract52(f3) '':nethany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By ethnic composition.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethbd2 + total1) by (nipract12 + base1) 
	/statistics cpct(nipract12(f3) '':nethbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By ethnic composition.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethbd2 + total1) by (nipract22 + base1) 
	/statistics cpct(nipract22(f3) '':nethbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By ethnic composition.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethbd2 + total1) by (nipract32 + base1) 
	/statistics cpct(nipract32(f3) '':nethbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By ethnic composition.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethbd2 + total1) by (nipract42 + base1) 
	/statistics cpct(nipract42(f3) '':nethbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By ethnic composition.

temp.
select if n10plus=2.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nethbd2 + total1) by (nipract52 + base1) 
	/statistics cpct(nipract52(f3) '':nethbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition - any disabled.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisabany + total1) by (nipract13 + base1) 
	/statistics cpct(nipract13(f3) '':ndisabany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition - any disabled.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisabany + total1) by (nipract23 + base1) 
	/statistics cpct(nipract23(f3) '':ndisabany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition - any disabled.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisabany + total1) by (nipract33 + base1) 
	/statistics cpct(nipract33(f3) '':ndisabany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition - any disabled.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisabany + total1) by (nipract43 + base1) 
	/statistics cpct(nipract43(f3) '':ndisabany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition - any disabled.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisabany + total1) by (nipract53 + base1) 
	/statistics cpct(nipract53(f3) '':ndisabany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisbd2 + total1) by (nipract13 + base1) 
	/statistics cpct(nipract13(f3) '':ndisbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisbd2 + total1) by (nipract23 + base1) 
	/statistics cpct(nipract23(f3) '':ndisbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisbd2 + total1) by (nipract33 + base1) 
	/statistics cpct(nipract33(f3) '':ndisbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisbd2 + total1) by (nipract43 + base1) 
	/statistics cpct(nipract43(f3) '':ndisbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By disabled composition.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ndisbd2 + total1) by (nipract53 + base1) 
	/statistics cpct(nipract53(f3) '':ndisbd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 16 to 21.

weight by estwtnr .
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21any + total1) by (nipract14 + base1) 
	/statistics cpct(nipract14(f3) '':n16t21any) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 16 to 21.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21any + total1) by (nipract24 + base1) 
	/statistics cpct(nipract24(f3) '':n16t21any) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 16 to 21.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21any + total1) by (nipract34 + base1) 
	/statistics cpct(nipract34(f3) '':n16t21any) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 16 to 21.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21any + total1) by (nipract44 + base1) 
	/statistics cpct(nipract44(f3) '':n16t21any) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 16 to 21.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21any + total1) by (nipract54 + base1) 
	/statistics cpct(nipract54(f3) '':n16t21any) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - proportion of employees aged 16 to 21.

weight by estwtnr .
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21d2 + total1) by (nipract14 + base1) 
	/statistics cpct(nipract14(f3) '':n16t21d2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - proportion of employees aged 16 to 21.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21d2 + total1) by (nipract24 + base1) 
	/statistics cpct(nipract24(f3) '':n16t21d2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - proportion of employees aged 16 to 21.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21d2 + total1) by (nipract34 + base1) 
	/statistics cpct(nipract34(f3) '':n16t21d2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - proportion of employees aged 16 to 21.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21d2 + total1) by (nipract44 + base1) 
	/statistics cpct(nipract44(f3) '':n16t21d2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - proportion of employees aged 16 to 21.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n16t21d2 + total1) by (nipract54 + base1) 
	/statistics cpct(nipract54(f3) '':n16t21d2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50plany + total1) by (nipract14 + base1) 
	/statistics cpct(nipract14(f3) '':n50plany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50plany + total1) by (nipract24 + base1) 
	/statistics cpct(nipract24(f3) '':n50plany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50plany + total1) by (nipract34 + base1) 
	/statistics cpct(nipract34(f3) '':n50plany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50plany + total1) by (nipract44 + base1) 
	/statistics cpct(nipract44(f3) '':n50plany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - any employees aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50plany + total1) by (nipract54 + base1) 
	/statistics cpct(nipract54(f3) '':n50plany) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - 25% aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50bd2 + total1) by (nipract14 + base1) 
	/statistics cpct(nipract14(f3) '':n50bd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - 25% aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50bd2 + total1) by (nipract24 + base1) 
	/statistics cpct(nipract24(f3) '':n50bd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - 25% aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50bd2 + total1) by (nipract34 + base1) 
	/statistics cpct(nipract34(f3) '':n50bd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - 25% aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50bd2 + total1) by (nipract44 + base1) 
	/statistics cpct(nipract44(f3) '':n50bd2) count(base1 'Weighted') u count(base1 'Unweighted') .

*By age composition - 25% aged 50 or more.

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (n50bd2 + total1) by (nipract54 + base1) 
	/statistics cpct(nipract54(f3) '':n50bd2) count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*Work-life balance.
***************************************************************.

***************************************************************.
*Hours of work.
***************************************************************.
***************************************************************.
*Flexible working arrangements.
***************************************************************.
** Figure 6 Flexible working arrangements

*Annual hours contracts.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nwtime2 + base1) 
	/statistics cpct(nwtime2(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nwtime2 + base1) 
	/statistics cpct(nwtime2(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*Any employees on zero hours contracts.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nwtime3 + base1) 
	/statistics cpct(nwtime3(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nwtime3 + base1) 
	/statistics cpct(nwtime3(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .
	
*Any employees on term-time only contracts.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nfamily1 + base1) 
	/statistics cpct(nfamily1(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nfamily1 + base1) 
	/statistics cpct(nfamily1(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*Any employees allowed to work from home.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nflex1 + base1) 
	/statistics cpct(nflex1(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nflex1 + base1) 
	/statistics cpct(nflex1(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*Any employees allowed to reduce hours.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nflex2 + base1) 
	/statistics cpct(nflex2(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nflex2 + base1) 
	/statistics cpct(nflex2(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*Any employees allowed to increase hours.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nflex3 + base1) 
	/statistics cpct(nflex3(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nflex3 + base1) 
	/statistics cpct(nflex3(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*Any employees allowed to job-share.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nflex4 + base1) 
	/statistics cpct(nflex4(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nflex4 + base1) 
	/statistics cpct(nflex4(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*Any employees allowed to work flexitime.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nflex5 + base1) 
	/statistics cpct(nflex5(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nflex5 + base1) 
	/statistics cpct(nflex5(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*Some employees able to change shift pattern.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nflex6 + base1) 
	/statistics cpct(nflex6(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nflex6 + base1) 
	/statistics cpct(nflex6(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*Some employees allowed to work compressed hours.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nflex7 + base1) 
	/statistics cpct(nflex7(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (nflex7 + base1) 
	/statistics cpct(nflex7(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

*End of tables for Figure 6 .

FILTER OFF .
*Proportion of workplaces with 2 or more flexible working practices (from PSA list).
*For all workplaces (for comparison with WLB2003).

*Standard breaks.
*Note this table is for workplaces with 5 plus employees.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nflex2p+ base1) 
	/statistics cpct(nflex2p(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*For workplaces with 10 plus employees only.
*Reapply filter .

FILTER BY filter_$.
EXECUTE .

weight by estwtnr.
temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (nflex2p+ base1) 
	/statistics cpct(nflex2p(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .


***************************************************************.
*Leave arrangements to support employees with caring responsibilities.
***************************************************************.

** Table 10 Extra-statutory leave arrangements to support employees with caring responsibilities, by sector of ownership.

* Provision of fully paid maternity leave.

temp. 
select if ztotwom>0.

*Whether fully paid maternity leave is being provided by workplace breaks .

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + n25pluso + NEMPSIZ7 + norgsize + nprivate + nsingle + nsicode + nrecog3+ nrecog2b + total1) by (imatfull + base1) 
	/statistics cpct(imatfull (f3) '':n25pluso NEMPSIZ7 norgsize nprivate nsingle nsicode nrecog3 nrecog2b) count(base1 'Weighted') u count(base1 'Unweighted') .

*Provision of maternity leave by union recognition, and by private and public sector.

temp.
select if nprivate = 1.

*Whether fully paid maternity leave is being provided by union recog - private sector only .

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nrecog3+ total1) by (imatfull + base1) 
	/statistics cpct(imatfull (f3) '':nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether fully paid maternity leave is being provided by union recog - public sector only .

temp.
select if nprivate = 2.

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nrecog3+ total1) by (imatfull + base1) 
	/statistics cpct(imatfull (f3) '':nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

* Whether fully paid maternity leave is being provided by hi/lo female presence.

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nfprop + nfpquart + nf50 + total1) by (iMATFULL + base1) 
	/statistics cpct(iMATFULL (f3) '':nfprop nfpquart nf50 ) count(base1 'Weighted') u count(base1 'Unweighted').

* Average number of weeks of paid maternity leave.  

weight by ESTWTNR .

temp.
select if imatfull =1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/observation=imatwks
	/table (imatwks + base1) by nallest
	/statistics mean(imatwks(f3) '') count(base1 'Weighted') u count(base1 'Unweighted') .


* Number of weeks of maternity leave by the standard breaks (omit missing values).

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + NEMPSIZ7 + norgsize +  nsingle + nprivate + nsicode + nrecog3+ total1) by (nmatwks2 + base1) 
	/statistics cpct(nmatwks2 (f3) '':NEMPSIZ7 norgsize nsingle  nprivate  nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .


*Number of weeks of maternity leave by proportion of females .

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nfprop + nfpquart + nf50 +  total1) by (Nmatwks2 + base1) 
	/statistics cpct(Nmatwks2 (f3) '':nfprop nfpquart nf50 ) count(base1 'Weighted') u count(base1 'Unweighted').


*Fully paid paternity leave.

temp.
select if ztotmen>0.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
            /table (nallest + nempsiz7 + n10pluso + n25pluso + norgsize  + nprivate + nsingle + nsicode + nrecog3 + nfpquart + total1) by (patlv + base1) 
	/statistics cpct(patlv (f3) '':nallest nempsiz7 n10pluso n25pluso norgsize nprivate nsingle nsicode nrecog3 nfpquart) count(base1 'Weighted') u count(base1 'Unweighted') .

*Number of days of paternity leave.

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
            /table (nallest + nempsiz7 + n10pluso + n25pluso + norgsize + nsme1 + nprivate + nsingle + nsicode + nrecog3 + nfpquart + total1) by (npatfull + base1) 
	/statistics cpct(npatfull (f3) '':nallest nempsiz7 n10pluso n25pluso norgsize nsme1 nprivate nsingle nsicode nrecog3 nfpquart) count(base1 'Weighted') u count(base1 'Unweighted') .


*Parental leave by standard workplace breaks.

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/mrgroup=parentlvmr 'How parents take time off outside of maternity, paternity, time off for emergencies' iparent1 to iparent6 xiparen1 to xiparen3
	/table (nallest + n25pluso + nempsiz7 + norgsize  + nprivate + nsingle + nsicode+ nrecog3 + total1) by (parentlvmr + base1) 
	/statistics cpct(parentlvmr(f3) '':n25pluso nempsiz7 norgsize nprivate nsingle nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .


*Paid parental leave or special paid leave by standard workplace breaks.
weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + n25pluso + nempsiz7 + norgsize + nsme1 + nprivate + nsingle + nsicode+ nrecog3 + total1) by (npaidpar+ base1) 
	/statistics cpct(npaidpar(f3) '':n25pluso nempsiz7 norgsize nsme1 nprivate nsingle nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

* Paid parental leave or special paid leave by proportion of female employees.

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nfpquart + nf50 + total1) by (npaidpar+ base1) 
	/statistics cpct(npaidpar(f3) '':nfpquart nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

* How employees usually take time off to deal with a family emergency by standard breaks. 

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/mrgroup=timeoffmr 'How employees usually take time off to deal with a family emergency' ifmoff1 to ifmoff8, xifmoff1 to xifmoff3
	/table (nallest + n25pluso + nempsiz7 + norgsize + nsme1 + nprivate + nsingle + nsicode+ nrecog3 + total1) by (timeoffmr + base1) 
	/statistics cpct(timeoffmr(f3) '':n25pluso nempsiz7 norgsize nsme1 nprivate nsingle nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

* Special paid leave by standard breaks

weight by ESTWTNR .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
            /table (nallest + nempsiz7 + n25pluso + norgsize + nsme1 + nprivate + nsingle + nsicode + total1) by (nspeclv + base1) 
	/statistics cpct(nspeclv (f3) '':nallest nempsiz7 n25pluso norgsize nsme1 nprivate nsingle nsicode) count(base1 'Weighted') u count(base1 'Unweighted').

* Non-emergency leave for carers.

*Carers leave by standard workplace breaks.

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + n25pluso + nempsiz7 + norgsize  + nprivate + nsingle + nsicode+ nrecog3 + total1) by (NCARElve+ base1) 
	/statistics cpct(NCARElve (f3) '':n25pluso nempsiz7 norgsize nprivate nsingle nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted').

* Mean number of days of paid paternity leave.

temp.
select if patlv =1.
frequencies variables = ipatfull
  /STATISTICS=MEAN
  /ORDER=  ANALYSIS . 

***************************************************************.
*Responsibility for managing work-life balance.
***************************************************************.
*Managers views on WLB.
*By standard breaks.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsiz7 + n25pluso + nsingle + norgsize + nprivate + nsicode + nrecog3 + total1) by (aphras04+ base1) 
	/statistics cpct(aphras04(f3) '': n25pluso nempsiz7 nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*By gender composition of workforce.

temp.
select if n10plus=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nf50 + total1) by (aphras04 + base1) 
	/statistics cpct(aphras04(f3) '':nf50) count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*Employee well-being.
***************************************************************.
***************************************************************.
*Job satisfaction.
***************************************************************.
***************************************************************.
*Job-related well-being.
***************************************************************.
***************************************************************.
*Management-employee relations.
***************************************************************.
** Table 13 Managers' and employees' perceptions of management-employee relations, 1998 and 2004.

*Managerial perception of employment relations .

WEIGHT by estwtnr.
fre Nrelate2.

***************************************************************.