*WERS 2004 SEQ FF tables.sps .

*Tables syntax for the WERS 2004 cross-section Employees survey.

*This file creates the tables and analysis based on the SEQ 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 files 'WERS 2004 MQ derived variables for FF.sps' and 'WERS 2004 SEQ derived variables for FF.sps' for this syntax to run successfully .


********************************************************************.
***User must first run derived variables syntax for SEQ .
*Note file path .

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

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


*********************.
* Additional notes .
*********************.
* The published figures for Table 11 Job satisfaction in First Findings are mistakenly based on unweighted data.
* The syntax in this file for Table 11 uses weighted data .
* However this makes little difference to the figures, the vast majority of the printed estimates are still correct .

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

USE ALL.
FILTER BY filter_$.
EXECUTE .

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


*Apply weights.

WEIGHT BY seqwtnr.

********************************************************************.
*Tables syntax follows.
********************************************************************.
********************************************************************.
*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.
***************************************************************.
***************************************************************.
*Location within larger organisations.
***************************************************************.
***************************************************************.
*The segmentation of employment.
***************************************************************.
***************************************************************.
*Younger and older employees.
***************************************************************.

***************************************************************.
*Gender segregation in management.
***************************************************************.

***************************************************************.
*Numerical flexibility.
***************************************************************.
***************************************************************.
*Recruitment, appraisal and training.
***************************************************************.
***************************************************************.
*Work organisation.
***************************************************************.
*Employee satisfaction with autonomy .

WEIGHT by seqwtnr.
temp .
select if ehiocc=1 .
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All employees'
	/autolabel=on
	/table (Eallemp + nrealtm2b + total1) by (a7a + base1) 
	/statistics cpct(a7a(f3) '':nrealtm2b) count(base1 'Weighted') u count(base1 'Unweighted')  
	/table (Eallemp + nrealtm2b + total1) by (a7b + base1) 
	/statistics cpct(a7b(f3) '':nrealtm2b) count(base1 'Weighted') u count(base1 'Unweighted')  
	/table (Eallemp + nrealtm2b + total1) by (a7c + base1) 
	/statistics cpct(a7c(f3) '':nrealtm2b) count(base1 'Weighted') u count(base1 'Unweighted')  
	/table (Eallemp + nrealtm2b + total1) by (a7d + base1) 
	/statistics cpct(a7d(f3) '':nrealtm2b) count(base1 'Weighted') u count(base1 'Unweighted')  
	/table (Eallemp + nrealtm2b + total1) by (a8b + base1) 
	/statistics cpct(a8b(f3) '':nrealtm2b) count(base1 'Weighted') u count(base1 'Unweighted')  
	/table (Eallemp + nrealtm2b + total1) by (a8c + base1) 
	/statistics cpct(a8c(f3) '':nrealtm2b) count(base1 'Weighted') u count(base1 'Unweighted')  .


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

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

* Union membership density - employee data .

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

***************************************************************.
*Representative voice.
***************************************************************.
***************************************************************.
*The roles and activities of employee representatives.
***************************************************************.
***************************************************************.
*Direct communication.
***************************************************************.
***************************************************************.
*Reward and remuneration.
***************************************************************.

***************************************************************.
*Methods of pay determination.
***************************************************************.
***************************************************************.
*Variable payment systems.
***************************************************************.
***************************************************************.
*Non-pecuniary rewards.
***************************************************************.
***************************************************************.
*Joint regulation of terms and conditions.
***************************************************************.
***************************************************************.
*Addressing workplace conflict.
***************************************************************.
***************************************************************.
*Grievance and disciplinary procedures.
***************************************************************.
***************************************************************.
*Collective disputes procedures.
***************************************************************.
***************************************************************.
*Equal opportunities policies and practices.
***************************************************************.
***************************************************************.
*Work-life balance.
***************************************************************.

***************************************************************.
*Hours of work.
***************************************************************.
*Proportion of employees working more than 48 hours a week by standard breaks.

*Workplaces with 10 plus employees only.

WEIGHT BY seqwtnr.
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 (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Gender (from SEQ) - All employees.
*Workplaces with 10 plus employees only.

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

*Gender (from SEQ) - Full-time employees only.
*Workplaces with 10 plus employees only.

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

*Long hours worked by men and women in male or female dominated workplaces.
*Workplaces with 10 plus employees only.

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

*Whether long hours working by men/women in male or female dominated workplaces varies by occupation.

WEIGHT BY seqwtnr.
temp.
select if n10plus=2 & esoc1=1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (e1gen + total1) by (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':e1gen) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether long hours working by men/women in male or female dominated workplaces varies by occupation.

WEIGHT BY seqwtnr.
temp.
select if n10plus=2 & esoc1=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (e1gen + total1) by (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':e1gen) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether long hours working by men/women in male or female dominated workplaces varies by occupation.

WEIGHT BY seqwtnr.
temp.
select if n10plus=2 & esoc1=3.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (e1gen + total1) by (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':e1gen) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether long hours working by men/women in male or female dominated workplaces varies by occupation.

WEIGHT BY seqwtnr.
temp.
select if n10plus=2 & esoc1=4.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (e1gen + total1) by (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':e1gen) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether long hours working by men/women in male or female dominated workplaces varies by occupation.

WEIGHT BY seqwtnr.
temp.
select if n10plus=2 & esoc1=5.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (e1gen + total1) by (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':e1gen) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether long hours working by men/women in male or female dominated workplaces varies by occupation.

WEIGHT BY seqwtnr.
temp.
select if n10plus=2 & esoc1=6.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (e1gen + total1) by (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':e1gen) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether long hours working by men/women in male or female dominated workplaces varies by occupation.

WEIGHT BY seqwtnr.
temp.
select if n10plus=2 & esoc1=7.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (e1gen + total1) by (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':e1gen) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether long hours working by men/women in male or female dominated workplaces varies by occupation.

WEIGHT BY seqwtnr.
temp.
select if n10plus=2 & esoc1=8.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (e1gen + total1) by (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':e1gen) count(base1 'Weighted') u count(base1 'Unweighted') .

*Whether long hours working by men/women in male or female dominated workplaces varies by occupation.

WEIGHT BY seqwtnr.
temp.
select if n10plus=2 & esoc1=9.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/table (e1gen + total1) by (ehrband + base1) 
	/statistics cpct(ehrband(f3) '':e1gen) count(base1 'Weighted') u count(base1 'Unweighted') .

*Frequency of working more than 48 hours a week by standard breaks.
*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 (e48hrs + base1) 
	/statistics cpct(e48hrs(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

*Gender (from SEQ) - for full-time employees only.
*Workplaces with 10 plus employees only.

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

***************************************************************.
*Flexible working arrangements.
***************************************************************.
*Base includes missings in order to make estimates comparable with the 1998 data, which did not include a 'don't know' option.
*This was necessary due to the large number of respondents who gave the 'don't know' response in 2004.

*Flexitime.
*By standard breaks.
*Workplaces with 10 plus employees only.

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

*Reduced hours.
*By standard breaks.
*Workplaces with 10 plus employees only.

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

*Increased working hours.
*By standard breaks.
*Workplaces with 10 plus employees only.

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

*Changing working pattern.
*By standard breaks.
*Workplaces with 10 plus employees only.

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

*Job-sharing.
*By standard breaks.
*Workplaces with 10 plus employees only.

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

*Compressed hours.
*By standard breaks.
*Workplaces with 10 plus employees only.

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

*Term-time only working.
*By standard breaks.
*Workplaces with 10 plus employees only.

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

*Homeworking.
*By standard breaks.
*Workplaces with 10 plus employees only.

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

*Access to flexible working arrangements by gender.

*Flexitime.
*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

*Job-sharing.
*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

*Homeworking.
*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

*Compressed working hours.
*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

*Reduced working hours.
*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

*Increased working hours.
*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

*Changing pattern of working hours.
*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

*Term-time only working.
*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

*Access to flexible working arrangements by gender composition of the workforce.

*Flexitime.
*Gender composition (from EPQ).
*Workplaces with 10 plus employees only.

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

*Job-sharing.
*Gender composition (from EPQ).
*Workplaces with 10 plus employees only.

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

*Homeworking.
*Gender composition (from EPQ).
*Workplaces with 10 plus employees only.

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

*Compressed working hours.
*Gender composition (from EPQ).
*Workplaces with 10 plus employees only.

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

*Reduced working hours.
*Gender composition (from EPQ).
*Workplaces with 10 plus employees only.

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

*Increased working hours.
*Gender composition (from EPQ).
*Workplaces with 10 plus employees only.

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

*Changing working pattern.
*Gender composition (from EPQ).
*Workplaces with 10 plus employees only.

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

*Term-time only working.
*Gender composition (from EPQ).
*Workplaces with 10 plus employees only.

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

*Access to flexible working practices by whether employee has dependent children - women only.

*Flexitime.
*By whether employee has dependent children.
*Workplaces with 10 plus employees only.

*Women only.
temp.
select if n10plus=2 & e1=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (eflexi + base1) 
	/statistics cpct(eflexi(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Job-sharing.
*By whether employee has dependent children.
*Workplaces with 10 plus employees only.
*Women only.

temp.
select if n10plus=2 & e1=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (ejobshr + base1) 
	/statistics cpct(ejobshr(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Homeworking.
*By whether employee has dependent children.
*Workplaces with 10 plus employees only.
*Women only.

temp.
select if n10plus=2 & e1=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (ehomewrk + base1) 
	/statistics cpct(ehomewrk(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Compressed hours.
*By whether employee has dependent children.
*Workplaces with 10 plus employees only.
*Women only.

temp.
select if n10plus=2 & e1=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (ecompres + base1) 
	/statistics cpct(ecompres(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Reduced hours.
*By whether employee has dependent children.
*Workplaces with 10 plus employees only.
*Women only.

temp.
select if n10plus=2 & e1=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (eredhrs + base1) 
	/statistics cpct(eredhrs(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Increased hours.
*By whether employee has dependent children.
*Workplaces with 10 plus employees only.
*Women only.

temp.
select if n10plus=2 & e1=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (eincrhrs + base1) 
	/statistics cpct(eincrhrs(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Changing working pattern.
*By whether employee has dependent children.
*Workplaces with 10 plus employees only.
*Women only.

temp.
select if n10plus=2 & e1=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (epattern + base1) 
	/statistics cpct(epattern(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Term-time only.
*By whether employee has dependent children.
*Workplaces with 10 plus employees only.
*Women only.

temp.
select if n10plus=2 & e1=2.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (etermtim + base1) 
	/statistics cpct(etermtim(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Access to flexible working practices by whether employee has dependent children - men only.

*Flexitime.
*Men only.

temp.
select if n10plus=2 & e1=1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (eflexi + base1) 
	/statistics cpct(eflexi(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Job-sharing.
*Men only.

temp.
select if n10plus=2 & e1=1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (ejobshr + base1) 
	/statistics cpct(ejobshr(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Homeworking.
*Men only.

temp.
select if n10plus=2 & e1=1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (ehomewrk + base1) 
	/statistics cpct(ehomewrk(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Compressed hours.
*Men only.

temp.
select if n10plus=2 & e1=1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (ecompres + base1) 
	/statistics cpct(ecompres(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Reduced hours.
*Men only.

temp.
select if n10plus=2 & e1=1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (eredhrs + base1) 
	/statistics cpct(eredhrs(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Increased hours.
*Men only.

temp.
select if n10plus=2 & e1=1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (eincrhrs + base1) 
	/statistics cpct(eincrhrs(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Changing working pattern.
*Men only.

temp.
select if n10plus=2 & e1=1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (epattern + base1) 
	/statistics cpct(epattern(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Term-time only.
*Men only.

temp.
select if n10plus=2 & e1=1.
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/autolabel=on
	/missing=include
	/base=qualified
	/table (eanydepc + total1) by (etermtim + base1) 
	/statistics cpct(etermtim(f3) '':eanydepc) count(base1 'Weighted') u count(base1 'Unweighted') .

*Access to flexible working arrangements by whether employee has caring responsibilities.

*Flexitime.
*Workplaces with 10 plus employees only.

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

*Job-sharing.
*By whether employee has caring responsibilities.
*Workplaces with 10 plus employees only.

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

*Homeworking.
*By whether employee has caring responsibilities.
*Workplaces with 10 plus employees only.

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

*Compressed working hours.
*By whether employee has caring responsibilities.
*Workplaces with 10 plus employees only.

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

*Reduced working hours.
*By whether employee has caring responsibilities.
*Workplaces with 10 plus employees only.

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

*Increased working hours.
*By whether employee has caring responsibilities.
*Workplaces with 10 plus employees only.

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

*Changing working pattern.
*By whether employee has caring responsibilities.
*Workplaces with 10 plus employees only.

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

*Term-time only working.
*By whether employee has caring responsibilities.
*Workplaces with 10 plus employees only.

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

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

*Employees views of whether managers understanding.

*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 (c2d + base1) 
	/statistics cpct(c2d(f3) '':nempsiz7 n25pluso nsingle norgsize nprivate nsicode nrecog3) count(base1 'Weighted') u count(base1 'Unweighted') .

*Gender composition (from EPQ).
*Workplaces with 10 plus employees only.

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

*Workplaces with 10 plus employees only.

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

*Gender (from SEQ).
*Workplaces with 10 plus employees only.

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

***************************************************************.
*Employee well-being.
***************************************************************.
***************************************************************.
*Job satisfaction.
***************************************************************.
** Table 11 Job satisfaction.

* The published figures for Table 11 Job satisfaction in First Findings are mistakenly based on unweighted data.
* The syntax in this file for Table 11 uses weighted data .
* However this makes little difference to the figures, the vast majority of the printed estimates are still correct .

weight by seqwtnr .
fre vars=Esatach Esatinit  Esatinf  Esattra  Esatpay  Esatjsec  Esatwork Esatinv.


* Frequency and histogram for the 8-variable scale .

fre esatsc8.

temp.
select if not missing(esatsc8).
factor
 /variables satach satinit satinf sattra satpay satjsec satwork satinv 
 /missing listwise
 /analysis satach satinit satinf sattra satpay satjsec satwork satinv 
 /print initial extraction rotation
 /criteria mineigen(1) iterate(25)
 /extraction pc
 /criteria iterate(25)
 /rotation varimax
 /method=correlation.

temp.
select if not missing(esatsc8).
RELIABILITY
  /VARIABLES=satach satinit satinf sattra satpay satjsec satwork satinv 
  /FORMAT=NOLABELS
  /SCALE(ALPHA)=ALL/MODEL=ALPHA
  /STATISTICS=SCALE CORR
  /SUMMARY=TOTAL CORR.

COMMENT	Check on extent to which variance accounted for by workplace clustering .

weight off.
exec.

Oneway esatsc8 by serno /stats=effects homogeneity welch.

COMMENT	Structural correlates of job satisfaction .
COMMENT	Use esatsc8 and N times satisfied on items (ie very sat or sat).

weight by seqwtnr.
exec.

fre Enjsat.

* Mean job satisfaction, 8 items .

temp.
select if not missing(esatsc8).
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All 10+ workplaces'
	/observation Enjsat
	/autolabel=on
	/table (nallest + n10pluso + n25pluso + nempsize + norgsize + nsme1 +  nprivate + nsingle + nsicode + xrecog3 + xrecog1 + nreptyp1 + njccf + total1)
	 by (Enjsat + base1) 
	/statistics mean((f4.1)) count(base1 'Weighted') u count(base1 'Unweighted') .

* Job satisfaction means, 8 item additive scale .

temp.
select if not missing(esatsc8).
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All 10+ workplaces'
	/observation esatsc8
	/autolabel=on
	/table (nallest + n10pluso + n25pluso + nempsize + norgsize + nsme1 +  nprivate + nsingle + nsicode + xrecog3 + xrecog1 + nreptyp1 + njccf + total1)
	 by (esatsc8 + base1) 
	/statistics mean((f4.1)) count(base1 'Weighted') u count(base1 'Unweighted') .
 


* Demographic correlates of job satisfaction .

* Mean job satisfaction, 8 items .

temp.
select if not missing(esatsc8).
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All 10+ workplaces'
	/observation Enjsat
	/autolabel=on
	/table (emale + eacavoc + ehiaca + emember + eage + total1)
	 by (Enjsat + base1) 
	/statistics mean((f4.1)) count(base1 'Weighted') u count(base1 'Unweighted') .

* Job satisfaction means, 8 item additive scale .

temp.
select if not missing(esatsc8).
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All 10+ workplaces'
	/observation esatsc8
	/autolabel=on
	/table (emale + eacavoc + ehiaca + emember + eage + total1)
	 by (esatsc8 + base1) 
	/statistics mean((f4.1)) count(base1 'Weighted') u count(base1 'Unweighted') .
 

***************************************************************.
*Job-related well-being.
***************************************************************.
** Table 12 Job-related well-being.

weight by seqwtnr .
exec.

fre vars = etense ecalm erelaxed eworried euneasy econtent.

COMMENT	Frequency for ewellsc. Higher scores mean 'well' ie less stressed.

fre ewellsc.


COMMENT	Factor analysis .

temp.
select if not missing(ewellsc).
factor
 /variables nottense calm relax notworried easy content 
 /missing listwise
 /analysis nottense calm relax notworried easy content 
 /print initial extraction rotation
 /criteria mineigen(1) iterate(25)
 /extraction pc
 /criteria iterate(25)
 /rotation varimax
 /method=correlation.

temp.
select if not missing(ewellsc).
RELIABILITY
  /VARIABLES=nottense calm relax notworried easy content 
  /FORMAT=NOLABELS
  /SCALE(ALPHA)=ALL/MODEL=ALPHA
  /STATISTICS=SCALE CORR
  /SUMMARY=TOTAL CORR.


temp.
select if not missing(ewellsc).
RELIABILITY
  /VARIABLES=nottense notworried easy 
  /FORMAT=NOLABELS
  /SCALE(ALPHA)=ALL/MODEL=ALPHA
  /STATISTICS=SCALE CORR
  /SUMMARY=TOTAL CORR.

COMMENT	Check on extent to which variance accounted for by workplace clustering .

weight off.
exec.

Oneway ewellsc by serno /stats=effects homogeneity welch.

* Structural correlates of employee stress .

weight by seqwtnr .
exec.

* Mean rating for employee well-being .

temp.
select if not missing(ewellsc).
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/observation ewellsc
	/autolabel=on
	/table (nallest + n10pluso + n25pluso + nempsize + norgsize + nsme1 +  nprivate + nsingle + nsicode + xrecog3 + xrecog1 + nreptyp1 + njccf + total1)
	 by (ewellsc + base1) 
	/statistics mean((f4.1)) count(base1 'Weighted') u count(base1 'Unweighted') .
  

* Demographic correlates of employee stress .

temp.
select if not missing(ewellsc).
tables 
	/format blank missing('.')
	/ftotal base1 'Base' total1 'All workplaces'
	/observation ewellsc
	/autolabel=on
	/table (emale + eacavoc + ehiaca + emember + eage + total1)
	 by (ewellsc + base1) 
	/statistics mean((f4.1)) count(base1 'Weighted') u count(base1 'Unweighted') .
  

***************************************************************.
*Management-employee relations.
***************************************************************.
** Table 13 Managers' and employees' perceptions of management-employee relations, 1998 and 2004.

weight by seqwtnr .
exec.

fre Eclimate.

* Whether employees were more or less negative about management-employee relations than their managers .

fre eclimviews.

***************************************************************.
*Summary.
***************************************************************.