*WERS 1998 MQ FF tables.sps.

*This syntax file produces the tables and analysis using the 1998 MQ reported in the FF 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 1998 MQ derived variables for FF.sps' for this syntax to run successfully .

*User must first run 'WERS 1998 MQ derived variables for FF.sps'.
*Note file path .

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

*********************.
* Additional notes .
*********************.
* Note that the syntax to replicate the figure of 16% of workplaces in 1998 with problem-solving groups involving non-managerial employees (Table 3) is not replicated here as the derivation of this figure is complex, please refer to note 13 in First Findings .
* Note that the proportion of workplaces with recognised unions in which members had access to a lay representative was 71% in 1998 (p. 13, Representative voice).
* The sentence reporting this result in FF should read as follows, “The proportion of workplaces with recognised unions in which members had access to a lay representative, either on-site or elsewhere in the organisation, was no different in 2004 (68%) than in 1998 (71%)” .
* In the section on Addressing Workplace Conflict, the syntax below gives a figure of 4.6% of workplaces having at least ten claims brought against them, compared with 4% reported in the text in First Findings .
* However, perhaps more importantly, note that the sentence reporting this result should read, “more than ten claims per thousand employees brought against them”.
* Note that for Table 6 this syntax shows that pay was set by management in 24% of workplaces in the public sector, in contrast to the 21% reported in First Findings .

*Apply weights.

weight by estwtnr.

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

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

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

***************************************************************.
*Coverage.
***************************************************************.

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

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

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

***************************************************************.
*A profile of workplaces.
***************************************************************.
***************************************************************.
*Industry and sector of ownership.
***************************************************************.
* Proportion of workplaces by broad sector .

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

***************************************************************.
*Location within larger organisations.
***************************************************************.
***************************************************************.
*The segmentation of employment.
***************************************************************.
***************************************************************.
*Younger and older employees.
***************************************************************.
***************************************************************.
*Gender segregation in management.
***************************************************************.
*Female under-representation in management.

*By standard breaks.

weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsize + nallwkpl + nsingle + norgsize + nprivate + asic + nrecog1 + total1) by (nfmgt2 + base1) 
	/statistics cpct(nfmgt2(f3) '': nempsize nallwkpl nsingle norgsize nprivate asic nrecog1) count(base1 'Weighted') u count(base1 'Unweighted') .

*Male under-representation in management.

*By standard breaks.

weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsize + nallwkpl + nsingle + norgsize + nprivate + asic + nrecog1 + total1) by (nmmgt2 + base1) 
	/statistics cpct(nmmgt2(f3) '': nempsize nallwkpl nsingle norgsize nprivate asic nrecog1) count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*Numerical flexibility.
***************************************************************.

*Part-time share of employment, by main classifications .

*By standard breaks.

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsize + nallwkpl + nsingle + norgsize + nprivate + asic + nrecog1 + total1) by (nptprop + base1) 
	/statistics cpct(nptprop(f3) '': nempsize nallwkpl nsingle norgsize nprivate asic nrecog1) count(base1 'Weighted') u count(base1 'Unweighted') .

*Incidence of non-standard employment.

*By standard breaks.

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsize + nallwkpl + nsingle + norgsize + nprivate + asic + nrecog1 + total1) by (nfixterm + base1) 
	/statistics cpct(nfixterm(f3) '': nempsize nallwkpl nsingle norgsize nprivate asic nrecog1) count(base1 'Weighted') u count(base1 'Unweighted') .

*Proportion of workplaces with any temporary agency workers by standard breaks.

tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsize + nallwkpl + nsingle + norgsize + nprivate + asic + nrecog1 + total1) by (jagency + base1) 
	/statistics cpct(jagency(f3) '': nempsize nallwkpl nsingle norgsize nprivate asic nrecog1) count(base1 'Weighted') u count(base1 'Unweighted') .

***************************************************************.
*Recruitment, appraisal and training.
***************************************************************.

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

* Use of personality tests .

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

* Use of performance tests .

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

*Any system of 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 (nmapprai + base1) 
	/statistics cpct(nmapprai(f3) '':nprivate) count(base1 'Weighted') u count(base1 'Unweighted') .

* Off the job training for experienced core employees .

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') .



***************************************************************.
*Work organisation.
***************************************************************.
** Table 3 Work organisation, by sector of ownership, 1998 and 2004.
* Note that the syntax to replicate the figure of 16% of workplaces in 1998 with problem-solving groups involving non-managerial employees is not replicated here as the derivation of this figure is complex, please refer to note 13 in First Findings .

* Incidence of team working .

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


* Functional flexibility .

weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsize + nsingle + norgsize + nprivate + asic + nrecog1 + nhiocc + total1) by (cothjob + base1) 
	/statistics cpct(cothjob(f3) '':nempsize nsingle norgsize nprivate asic nrecog1 nhiocc) count(base1 'Weighted') u count(base1 'Unweighted') 
 	/table (nallest + nempsize + nsingle + norgsize + nprivate + asic + nrecog1 + nhiocc + total1) by (nfunc+ base1) 
	/statistics cpct(nfunc(f3) '':nempsize nsingle norgsize nprivate asic nrecog1 nhiocc) count(base1 'Weighted') u count(base1 'Unweighted') .


* Trained in team-working, communication or problem-solving .

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

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

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

* Union density .

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

***************************************************************.
*Representative voice.
***************************************************************.
* Union recognition .

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

* Union recognition (employee weighted) .

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

* Recognition in workplaces with 25 or more employees .

temp .
select if zallemps>=25 .
weight by estwtnr .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsize + nsingle + norgsize + nprivate + asic + total1) by (nrecog1 + base1) 
	/statistics cpct(nrecog1(f3) '':nempsize nsingle norgsize nprivate asic ) count(base1 'Weighted') u count(base1 'Unweighted') .


* Proportion of workplaces with recognised unions in which members had access to a lay representative .
* Note that the proportion of workplaces with recognised unions in which members had access to a lay representative was 71% in 1998 (p. 13, Representative voice).
* The sentence reporting this result in FF should read as follows, "The proportion of workplaces with recognised unions in which members had access to a lay representative, either on-site or elsewhere in the organisation, was no different in 2004 (68%) than in 1998 (71%)" .

weight by estwtnr .
temp .
select if nrecog1=2 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsize + nsingle + norgsize + nprivate + asic + total1) by (nerep + base1) 
	/statistics cpct(nerep(f3) '':nempsize nsingle norgsize nprivate asic ) count(base1 'Weighted') u count(base1 'Unweighted') .

* Whether access to lay representative at own workplace .

weight by estwtnr .
temp .
select if nrecog1=2 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
 	/table (nallest + nempsize + nsingle + norgsize + nprivate + asic + total1) by (esteward + base1) 
	/statistics cpct(esteward(f3) '':nempsize nsingle norgsize nprivate asic ) count(base1 'Weighted') u count(base1 'Unweighted') .

* Presence of joint consultative committee.

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

* Types of joint consultative committee .

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

* Proportion of employees in a workplace with a workplace-level JCC .

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


***************************************************************.
*The roles and activities of employee representatives.
***************************************************************.
***************************************************************.
*Direct communication.
***************************************************************.

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

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') .

* Note that the categories noticeboards, email and intranet are omitted from the First Findings table for 1998 .
* This is because these categories were backcoded in 1998, rather than all respondents being asked whether any of these forms of communication were used, as in 2004.

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

* Suggestion schemes .

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

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

***************************************************************.
*Methods of pay determination.
***************************************************************.
** Table 6 Pay determination methods, 1998 and 2004.

* Variety of pay determination methods used at workplace, by sector .
* Note that for Table 6 this syntax shows that pay was set by management in 24% of workplaces in the public sector, in contrast to the 21% reported in First Findings .

WEIGHT by estwtnr.

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


* Coverage of pay determination methods for all employees, by main classifications .
* The following syntax replicates the figures for the final paragraph of this section for 1998, indicating the proportion of employees whose pay is set by collective bargaining or management .
* 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.
exec.
tables
  /format blank missing('.')
  /ftotal base1 'Base' total1 'All workplaces'
  /observation ncbmulta ncborga ncbworka nsetorga nsetworka nindnega npayreva
  /tables (nallest + nempsize + norgsize + nprivate + asic + nsector3 + nsingle + nrecog1 + total1) 
  by  (ncbmulta + ncborga + ncbworka + nsetorga + nsetworka + nindnega + npayreva + base1) 
  /statistics mean((F5.0)) validn(base1 'Weighted') u validn(base1 'Unweighted') .

***************************************************************.
*Variable payment systems.
***************************************************************.
***************************************************************.
*Non-pecuniary rewards.
***************************************************************.
* Single status, managers and other employees have equal conditions .

WEIGHT by estwtnr.
FREQUENCIES
	VARIABLES=nss3
	/ORDER= ANALYSIS.

***************************************************************.
*Joint regulation of terms and conditions.
***************************************************************.
***************************************************************.
*Addressing workplace conflict.
***************************************************************.

* Incidence of collective disputes in the last 12 months. 

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

*Incidence of industrial action .

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

*Threatened industrial action .

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


* Volume of employment tribunal cases

* Incidence of employment tribunal claims brought 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 (nitclaim + base1) by nallest
	/statistics cpct(nitclaim (f3) '': nallest) count(base1 'Weighted') u count(base1 'Unweighted') .


*Incidence of employment tribunal claims by standard workplace breaks .

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


* Proportion of workplaces with more than ten claims brought against them in the past year . 
* Note this gives a figure of 4.6% of workplaces having at least ten claims brought against them, compared with 4% reported in the text in First Findings .
* However, perhaps more importantly, note that the sentence reporting this result 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 in 1998.

weight by estwtnr .
tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/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 grievance procedures .

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

* Incidence of disciplinary procedures .

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



***************************************************************.
*Collective disputes procedures.
***************************************************************.
***************************************************************.
*Equal opportunities policies and practices.
***************************************************************.

weight by estwtnr.

* Workplaces with a formal written equal opportunities policy . 

tables	
            /format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (ipolicy + base1) by nallest
	/statistics cpct(ipolicy(f3) '': nallest) 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').

* Grounds covered by equal opportunities policy .

temp. 
select if ipolicy=1. 
tables 
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/mrgroup=igrounmr 'Coverage of eo policy' igroun01 igroun02 igroun03 igroun04 igroun05 igroun06 igroun07 igroun08 igroun09 
	/table (igrounmr + base1) by nallest
	/statistics cpct(igrounmr(f3) '':nallest) count(base1 'Weighted') u count(base1 'Unweighted') .



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

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

***************************************************************.
*Leave arrangements to support employees with caring responsibilities.
***************************************************************.
***************************************************************.
*Responsibility for managing work-life balance.
***************************************************************.

*Managers views on work-life balance.

*By standard breaks.
weight by estwtnr.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (nallest + nempsize + nallwkpl + nsingle + norgsize + nprivate + asic + nrecog1 + total1) by (aphras04+ base1) 
	/statistics cpct(aphras04(f3) '': nempsize nallwkpl nsingle norgsize nprivate asic nrecog1) 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 1998 .

WEIGHT by estwtnr.
fre Mrelate.

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