*WERS 2004 SEQ derived variables for FF.sps. *This syntax file derives the SEQ variables used in the 2004 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 . ************************************************. *List of derived variables. ************************************************. ** Recode age into 6 bands (Eage). ** All employees dummy (Eallemp) . ** Usual weekly hours (Ehours) . ** Banded hours as per 1998 variable (Ehrband) . ** Gender of employee relative to gender composition of workforce (E1gen) . ** Occupation code - Major Group (Esoc1) . ** Occupation code - Sub-Major Group (Esoc2) . ** Occupation code - Minor Group (Esoc3) . ** Occupation code - Unit Group (Esoc4) . ** Employee is in largest non-managerial group (Ehiocc) . ** Frequency of working more than 48 hours a week (E48hrs) . ** Recode total weekly hours into full-time/part-time (Eftpt) . ** Availability of flexi-time working - Derived variable for B1a (Eflexi). ** Availability of job sharing - Derived variable for B1b (Ejobshr). ** Option to reduce working hours eg from FT to PT - Derived variable for B1c (Eredhrs) . ** Option to increase working hours e.g. from PT to FT - Derived variable for B1d (Eincrhrs) . ** Availability of homeworking - Derived variable for B1e (Ehomewrk) . ** Option to change working patterns - Derived variable for B1f (Epattern) . ** Availability of compressed hours working - Derived variable for B1g (Ecompres) . ** Availability of term time working - Derived variable for B3a (Etermtim) . ** Any dependent children (Eanydepc). ** Dependent children, pre- and/or school age (Edepch). ** Any dependent children (Edepch2). ** Derived variable for E5 - Whether employee has caring responsibilities or not (Ecaringresp) . ** Satisfaction with sense of achievement from work (Esatach) . ** Satisfaction with scope for using own initiative (Esatinit) . ** Satisfaction with amount of influence over own job (Esatinf) . ** Satisfaction with training received (Esattra) . ** Satisfaction with amount of pay received (Esatpay) . ** Satisfaction with job security (Esatjsec) . ** Satisfaction with the work itself (Esatwork) . ** Satisfaction with involvement in decision-making at workplace (Esatinv) . ** Additive job satisfaction scale, 8 items (Esatsc8) . ** N items employees are satisfied or very satisfied (Enjsat) . ** If male (Emale) . ** Highest vocational qualification (Ehivoc) . ** Highest academic qualification (Ehiaca) . ** Whether academic qualifications only, vocational only, both or none (Eacavoc) . ** Union Membership (Emember) . ** Amount of time feeling tense in past few weeks (Etense) . ** Amount of time calm in last few weeks (Ecalm) . ** Amount of time relaxed in last few weeks (Erelaxed) . ** Amount of time worried in last few weeks (Eworried) . ** Amount of time uneasy in last few weeks (Euneasy) . ** Amount of time content in last few weeks (Econtent) . ** Additive employee well-being scale, 6 items (Ewellsc) . ** Relations between managers and employees (Eclimate) . ** Variable identifying how employee perceptions differ from employer (Eclimviews) . ********************************************************************. ***User should first run derived variables syntax for MQ . ********************************************************************. *Note file path . include 'C:\WERS\WERS 2004 MQ derived variables for FF.sps'. *Note file path . *Save. save outfile='C:\WERS\WERS 2004 MQ with derived variables.sav'. ********************************************************************. *Then match with SEQ data . ********************************************************************. *Open SEQ data. *Note file path . GET FILE='C:\WERS\xs04_seq.sav'. execute. ********************************************************************. *Match SEQ data with MQ data. ********************************************************************. match files file=*/table='C:\WERS\WERS 2004 MQ with derived variables.sav'/by serno. EXECUTE. ********************************************************************. ******************************************************* . *Derived variables . ******************************************************* . COMMENT Age (Eage) . Numeric Eage (f3.0). recode E2 (8 thru 9=6)(7=5)(6=4)(5=3)(3 thru 4=2)(1 thru 2=1)(else=-9) INTO eage. variable labels eage 'Respondents age'. value labels eage 1 'less than 20 years' 2 'between 20 and 29' 3 'between 30 and 39' 4 'between 40 and 49' 5 'between 50 and 59' 6 '60 years or more' -9 'Not answered'. missing values eage (-9). execute. **************************************************************** . COMMENT All employees dummy (Eallemp) . Numeric Eallemp (F1.0). compute Eallemp=1. variable labels Eallemp 'All employees'. value labels Eallemp 1 'All employees'. execute. **************************************************************** . COMMENT Hours worked (Ehours) . Numeric Ehours (f4.2) . recode a3 (0=-9) (else=copy) into ehours. if a3_dec>=.50 ehours=ehours+1. variable label ehours 'usual weekly hours'. value labels ehours -9 'Not answered'. missing values ehours (-9). exec . **************************************************************** . COMMENT Banded hours as per 1998 variable (Ehrband) . Numeric Ehrband (f3.0). recode ehours (1 thru 9=1) (10 thru 29=2) (30 thru 48=3) (49 thru hi=4) (else=-9) into ehrband. variable labels ehrband 'Usual weekly hours - banded'. value labels ehrband 1 'Less than 10 hours per week' 2 '10 to 29 hours per week' 3 '30 to 48 hours per week' 4 'More than 48 hours per week' -9 'DK/NA'. missing values ehrband (-9). exec. **************************************************************** . COMMENT Gender of employee relative to gender composition of workforce (e1gen) . numeric e1gen (f3.0). recode e1 (-1=copy)(-9=-8) into e1gen. recode nf50 (-1, -8=copy) into e1gen. do if e1=1 & nf50=0. compute e1gen=1. else if e1=2 & nf50=0. compute e1gen=2. else if e1=1 & nf50=1. compute e1gen=3. else if e1=2 & nf50=1. compute e1gen=4. end if. execute. missing values e1gen (-1, -8). variable label e1gen 'Gender of employee relative to gender composition of workforce'. value labels e1gen 1 'Male in equal/male-dominated workplace' 2 'Female in equal/male-dominated workplace' 3 'Male in female-dominated workplace' 4 'Female in female-dominated workplace' -1 'Not applicable' -8 'DK/NA'. **************************************************************** . COMMENT Occupation (Esoc1, Esoc2, Esoc3, Esoc4) . Numeric Esoc1 Esoc2 Esoc3 Esoc4 (f5.0) . do if missing(xsoc2000)=1. + compute esoc1=-9 . + compute esoc2=-9 . + compute esoc3=-9 . + compute esoc4=-9 . else if missing(xsoc2000)=0. + compute esoc4=xsoc2000 . + compute esoc3=trunc(xsoc2000/10) . + compute esoc2=trunc(xsoc2000/100) . + compute esoc1=trunc(xsoc2000/1000) . end if . missing values Esoc1 to Esoc4 (-9) . variable labels Esoc1 "Occupation - Major Group" /Esoc2 "Occupation - Sub-Major Group" /Esoc3 "Occupation - Minor Group" /Esoc4 "Occupation - Unit Group" . value labels Esoc1 1 "Managers and Senior Officials" 2 "Professional Occupations" 3 "Associate Professional and Technical Occupations" 4 "Administrative and Secretarial Occupations" 5 "Skilled Trades" 6 "Personal Service Occupations" 7 "Sales and Customer Service Occupations" 8 "Process, Plant and Machine Operatives" 9 "Elementary Occupations" . add value labels Esoc1 to Esoc4 -9 "DK/NA". execute . **************************************************************** . COMMENT Employee in largest non-managerial group at workplace (Ehiocc) . Numeric Ehiocc (f3.0). do if missing(esoc1) . + compute Ehiocc=-9. else if missing(esoc1)=0 and esoc1=1 . + compute Ehiocc=8. else if missing(esoc1)=0 and esoc1>1 and missing(nhiocc) . + compute Ehiocc=-8. else if missing(esoc1)=0 and esoc1>1 and missing(nhiocc)=0 and esoc1=nhiocc . + compute Ehiocc=1. else if missing(esoc1)=0 and esoc1>1 and missing(nhiocc)=0 and esoc1~=nhiocc . + compute Ehiocc=2. end if. missing values Ehiocc (-8,-9). variable labels Ehiocc 'Employee in largest occupational group at workplace'. value labels Ehiocc 1 'Employee in LOG' 2 'Employee in other non-managerial group' 8 'Manager' -8 'Nhiocc missing' -9 'SOC code missing'. execute. **************************************************************** . COMMENT Long hours working (E48hrs) . *Frequency of working more than 48 hours a week (e48hrs) . numeric E48hrs (f3.0). recode a5 (1 thru 5 = copy)(-6=copy) (else=-9) into e48hrs. variable label e48hrs 'Frequency of working more than 48 hours a week'. value labels e48hrs 1 'Every week' 2 '2 or 3 times a month' 3 'Once a month' 4 'Less often than once a month' 5 'Never' -6 'Multicoded' -9 'Not answered'. missing values e48hrs (-6, -9). execute. **************************************************************** . COMMENT FT/PT status (Eftpt) . Numeric Eftpt (f3.0). recode ehours (1 thru 29=1) (30 thru hi=2) (else=-9) into eftpt. variable labels eftpt 'Full- or part-time worker'. value labels eftpt 1 'Part-time (less than 30 hours per week)' 2 'Full-time (30 or more hours per week)' -9 'DK/NA'. missing values eftpt (-9). exec . **************************************************************** . COMMENT Availability of flexible / family-friendly working arrangements (Eflexi, Ejobshr, Eredhrs, Einchrs, Ehomewrk, Epattern, Ecompres, Etermtim, Eparentl, Echildcr) . *Derived variable for B1a - availability of flexi-time (Eflexi) . numeric eflexi (f3.0). RECODE B1a (-8=-9) (0=-9) (ELSE=Copy) INTO eflexi. missing values eflexi (-9, -6). VARIABLE LABELS eflexi 'Availability of flexi-time'. value labels eflexi 1'Yes' 2 'No' -9 'DK/Not Answered' -6 'Multi-coded'. EXECUTE . *Derived variable for B1b - availability of jobsharing (Ejobshr) . Numeric ejobshr (f3.0). RECODE B1b (-8=-9) (0=-9) (ELSE=Copy) INTO ejobshr. missing values ejobshr (-9, -6). VARIABLE LABELS ejobshr 'Availability of job-sharing'. value labels ejobshr 1'Yes' 2 'No' -9 'DK/Not Answered' -6 'Multi-coded'. EXECUTE . *Derived variable for b1c - Option to reduce working hours e.g. from FT to PT (Eredhrs) . Numeric eredhrs (f3.0). RECODE B1c (-8=-9) (0=-9) (ELSE=Copy) INTO eredhrs. missing values eredhrs (-9, -6). VARIABLE LABELS eredhrs 'Chance to reduce working hours e.g. from FT to PT'. value labels eredhrs 1'Yes' 2 'No' -9 'DK/Not Answered' -6 'Multi-coded'. EXECUTE . *Derived variable for b1d - Option to increase working hours e.g. from PT to FT (Eincrhrs) . Numeric eincrhrs (f3.0). RECODE B1d (-8=-9) (0=-9) (ELSE=Copy) INTO eincrhrs. missing values eincrhrs (-9, -6). VARIABLE LABELS eincrhrs 'Chance to increase working hours e.g. from PT to FT'. value labels eincrhrs 1'Yes' 2 'No' -9 'DK/Not Answered' -6 'Multi-coded'. EXECUTE . *Derived variable for b1e - Availability of homeworking (Ehomewrk) . Numeric ehomewrk (f3.0). RECODE B1e (-8=-9) (0=-9) (ELSE=Copy) INTO ehomewrk. missing values ehomewrk (-9, -6). VARIABLE LABELS ehomewrk 'Availability of homeworking'. value labels ehomewrk 1'Yes' 2 'No' -9 'DK/Not Answered' -6 'Multi-coded'. EXECUTE . *Derived variable for b1f - Changing working patterns incl. shifts (Epattern) . Numeric epattern (f3.0). RECODE B1f (-8=-9) (0=-9) (ELSE=Copy) INTO epattern. missing values epattern (-9, -6). VARIABLE LABELS epattern 'Changing working patterns, including shifts'. value labels epattern 1'Yes' 2 'No' -9 'DK/Not Answered' -6 'Multi-coded'. EXECUTE . *Derived variable for b1g - Compressed hours (Ecompres) . Numeric ecompres (f3.0). RECODE B1g (-8=-9) (0=-9) (ELSE=Copy) INTO ecompres. missing values ecompres (-9, -6). VARIABLE LABELS ecompres 'Working the same number of hours per week across fewer days'. value labels ecompres 1'Yes' 2 'No' -9 'DK/Not Answered' -6 'Multi-coded'. EXECUTE . *Derived variable for B3a - availability of term time working (Etermtim) . numeric etermtim (f3.0). RECODE B3a (missing=-9) (0=-9) (ELSE=Copy) INTO etermtim. missing values etermtim (-9). VARIABLE LABELS etermtim 'Availability of term-time working'. value labels etermtim 1'Yes' 2 'No' -9 'DK/Not Answered'. EXECUTE . **************************************************************** . COMMENT Dependent children (Edepch) . COMPUTE E42a=E4_2. RECODE E4_3 (1=1) INTO E43a. RECODE E4_4 (1=2) INTO E44a. RECODE E4_5 (1=2) INTO E45a. RECODE E4_6 (1=2) INTO E46a. RECODE E4_1 (1=0) INTO E41a. EXECUTE. Numeric Edepch (f1). do if (missing (E4)=1). + compute Edepch=-9. else if (E4=1). + compute Edepch = sum(E42a TO E41a). end if. do if (E4>1 & (E4_2=0 & E4_3=0)). + compute Edepch=2. else if (E4>1 & (E4_4=0 & E4_5=0 & E4_6=0)). + compute Edepch=1. else if E4>1 & (missing (Edepch)=1). + compute Edepch=3. end if. execute. delete variables e42a to e41a. missing values Edepch (-9). variable labels Edepch 'Any dependent children'. value labels Edepch 0 'No dependent children' 1 'Children, pre-school' 2 'Children, school age' 3 'Children, both pre and school age' -9 'Not answered'. Execute. **************************************************************** . COMMENT Any dependent children (eanydepc). numeric eanydepc (f3.0). recode edepch (0=0)(1, 2,3=1)(-1, -8, -9=copy) into eanydepc. missing values eanydepc (-1, -8, -9). variable label eanydepc 'Any dependent children'. value labels eanydepc 1 'Yes' 0 'No' -1 'Not applicable' -8 'Do not know' -9 'Not answered'. execute. **************************************************************** . COMMENT Employee has caring responsibilities relating to age, illness or disability (Ecaringresp) . numeric Ecaringresp (f3.0). RECODE e5 (MISSING=Copy) (1=2) (ELSE=1) INTO Ecaringresp . VARIABLE LABELS Ecaringresp 'Caring responsibilities incl elder care, long term illness or disability'. Value labels Ecaringresp 1 'Caring responsibilities' 2 'No caring responsibilities'. Missing values Ecaringresp (-9). EXECUTE . **************************************************************** . COMMENT Job satisfaction (Esatach, Esatinit, Esatinf, Esattra, Esatpay, Esatjsec, Esatwork, Esatinv, Esatsc8) . COMMENT Satisfaction with particular aspects of job (Esatach, Esatinit, Esatinf, Esattra, Esatpay, Esatjsec, Esatwork) . Numeric Esatach Esatinit Esatinf Esattra Esatpay Esatjsec Esatwork (f2.0) . recode a8a a8b a8c a8d a8e a8f a8g (0=-9) (else=copy) into Esatach Esatinit Esatinf Esattra Esatpay Esatjsec Esatwork. variable labels Esatach "Satisfaction with sense of achievement from work" /Esatinit "Satisfaction with scope for using own initiative" /Esatinf "Satisfaction with amount of influence over own job" /Esattra "Satisfaction with training received" /Esatpay "Satisfaction with amount of pay received" /Esatjsec "Satisfaction with job security" /Esatwork "Satisfaction with the work itself". value labels Esatach Esatinit Esatinf Esattra Esatpay Esatjsec Esatwork 1 'Very satisfied' 2 'Satisfied' 3 'Neither satisfied nor dissatisfied' 4 'Dissatisfied' 5 'Very dissatisfied' -6 'Multi-coded' -8 'Do not know' -9 'Not answered'. missing values Esatach Esatinit Esatinf Esattra Esatpay Esatjsec Esatwork (-9 to -6). exec . COMMENT Satisfaction with involvement in decision-making (Esatinv) . Numeric Esatinv (f2.0) . recode b9 (0=-9) (else=copy) into Esatinv. variable labels Esatinv "Satisfaction with involvement in decision-making at workplace". value labels Esatinv 1 'Very satisfied' 2 'Satisfied' 3 'Neither satisfied nor dissatisfied' 4 'Dissatisfied' 5 'Very dissatisfied' -6 'Multi-coded' -8 'Do not know' -9 'Not answered'. missing values Esatinv (-9 to -6). exec . COMMENT Single additive scale for job satisfaction using all 8 items (Esatsc8) . Numeric Esatsc8 (f2.0) . recode Esatach (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into satach. recode Esatinit (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into satinit. recode Esatinf (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into satinf. recode Esattra (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into sattra. recode Esatpay (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into satpay. recode Esatjsec (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into satjsec. recode Esatwork (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into satwork. recode Esatinv (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into satinv. missing values satach satinit satinf sattra satpay satjsec satwork satinv (-9). exec. do if not missing(satach) and not missing(satinit) and not missing(satinf) and not missing(sattra) and not missing(satpay) and not missing(satjsec) and not missing(satwork) and not missing(satinv). + compute Esatsc8 = sum(satach,satinit,satinf,sattra,satpay,satjsec,satwork,satinv). end if. if missing(satach) or missing(satinit) or missing(satinf) or missing(sattra) or missing(satpay) or missing(satjsec) or missing(satwork) or missing(satinv) Esatsc8=-9. variable label Esatsc8 "Additive job satisfaction scale, 8 items". value labels Esatsc8 -9 'DK/NA'. missing values Esatsc8 (-9). exec . **************************************************************** . COMMENT N items employees are satisfied or very satisfied (Enjsat) . count Enjsat=satach satinit satinf sattra satpay satjsec satwork satinv (1,2). if missing(esatsc8) Enjsat=-9. variable label Enjsat 'N items employees are satisfied or very satisfied'. value labels Enjsat -9 'DK/NA'. missing values Enjsat (-9). **************************************************************** . COMMENT If male (Emale) . Numeric Emale (f1.0). recode e1 (0=-9) (2=0) (else=copy) into emale. value labels emale 0 'female' 1 'male' -9 'DK/Not answered'. variable label emale 'if male'. missing values emale (-9). exec . **************************************************************** . COMMENT Highest vocational or professional qualification (Ehivoc) . Numeric Ehivoc (f3.0). compute ehivoc=-9. if e8_9=1 ehivoc=0. if e8_7=1 ehivoc=1. if e8_1=1 ehivoc=2. if e8_2=1 ehivoc=3. if e8_6=1 ehivoc=4. if e8_3=1 ehivoc=5. if e8_8=1 ehivoc=6. if e8_4=1 ehivoc=7. if e8_5=1 ehivoc=8. variable label ehivoc 'highest vocational or professional qualification'. value labels ehivoc 0 'None' 1 'Other vocational/pre-vocational' 2 'Level 1' 3 'Level 2' 4 'Completion of trade apprenticeship' 5 'Level 3' 6 'Other professional qualification' 7 'Level 4' 8 'Level 5' -9 'DK/NA'. missing values ehivoc (-9). exec . **************************************************************** . COMMENT Highest academic qualification (Ehiaca) . Numeric Ehiaca (f3.0). compute ehiaca=-9. if e7_8=1 ehiaca=0. if e7_7=1 ehiaca=1. if e7_1=1 ehiaca=2. if e7_2=1 ehiaca=3. if e7_3=1 ehiaca=4. if e7_4=1 ehiaca=5. if e7_5=1 ehiaca=6. if e7_6=1 ehiaca=7. variable label ehiaca 'highest academic qualification'. value labels ehiaca 0 'None' 1 'Other' 2 'CSE or equiv' 3 'O level or equiv' 4 '1 A level or equiv' 5 '2+ A level or equiv' 6 'Degree or equiv' 7 'Postgrad or equiv' -9 'DK/NA'. missing values ehiaca (-9). exec . **************************************************************** . COMMENT Variable identifying whether voc only, aca only, both or neither (Eacavoc) . Numeric Eacavoc (f3.0). compute eacavoc=-9. if ehivoc=0 and ehiaca=0 Eacavoc=0. if ehivoc>0 and not missing(ehivoc) Eacavoc=1. if ehiaca>0 and not missing(ehiaca) Eacavoc=2. if ehivoc>0 and not missing(ehivoc) and ehiaca>0 and not missing(ehiaca) Eacavoc=3. variable label eacavoc 'Whether vocactional quals, academic or both'. value labels eacavoc 0 'Neither' 1 'Vocational/professional only ' 2 'Academic only' 3 'Both' -9 'DK/NA'. missing values Eacavoc (-9). exec . **************************************************************** . COMMENT Union membership status (Emember) . Numeric Emember (f3.0). recode d1 (2 thru 3=2) (1=1) (else=-9) into Emember. variable labels Emember 'Whether union member'. value labels Emember 1 'Yes union member' 2 'Not union member' -9 'DK/NA'. missing values Emember (-9). exec. **************************************************************** . COMMENT Employee well-being at A9 (Etense, Ecalm, Erelaxed, Eworried, Euneasy, Econtent, Ewellsc) . COMMENT Individual items (Etense, Ecalm, Erelaxed, Eworried, Euneasy, Econtent) . Numeric Etense Ecalm Erelaxed Eworried Euneasy Econtent (f2.0) . recode a9a a9b a9c a9d a9e a9f (0=-9) (else=copy) into Etense Ecalm Erelaxed Eworried Euneasy Econtent. variable labels Etense "Amount of time feeling tense in past few weeks" /Ecalm "Amount of time calm in last few weeks" /Erelaxed "Amount of time relaxed in last few weeks" /Eworried "Amount of time worried in last few weeks" /Euneasy "Amount of time uneasy in last few weeks" /Econtent "Amount of time content in last few weeks". value labels Etense Ecalm Erelaxed Eworried Euneasy Econtent 1 'All of the time' 2 'Most of the time' 3 'Some of the time' 4 'Occasionally' 5 'Never' -6 'Multi-coded' -8 'Do not know' -9 'Not answered'. missing values Etense Ecalm Erelaxed Eworried Euneasy Econtent (-9 to -6). exec . COMMENT Well-being scale (Ewellsc) . COMMENT Recode items into (-2,2) variables POINTING IN SAME DIRECTION recode Etense (1 = -2) (2 = -1) (3 = 0) (4 = 1) (5 = 2) (else = -9) into nottense. recode Ecalm (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into calm. recode Erelaxed (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into relax. recode Eworried (1 = -2) (2 = -1) (3 = 0) (4 = 1) (5 = 2) (else = -9) into notworried. recode Euneasy (1 = -2) (2 = -1) (3 = 0) (4 = 1) (5 = 2) (else = -9) into easy. recode Econtent (1 = 2) (2 = 1) (3 = 0) (4 = -1) (5 = -2) (else = -9) into content. missing values nottense calm relax notworried easy content (-9). exec . do if not missing(nottense) and not missing(calm) and not missing(relax) and not missing(notworried) and not missing(easy) and not missing(content). + compute Ewellsc = sum(nottense,calm,relax,notworried,easy,content). end if. if missing(nottense) or missing(calm) or missing(relax) or missing(notworried) or missing(easy) or missing(content) Ewellsc=-9. variable label Ewellsc "Additive employee well-being scale, 6 items". value labels Ewellsc -9 'DK/NA'. missing values Ewellsc (-9). exec . **************************************************************** . COMMENT Employee perceptions of climate (Eclimate) . Numeric Eclimate (f2.0) . recode c3 (0=-9) (else=copy) into Eclimate. variable label Eclimate "Employee perceptions of relations between managers and employees". value labels Eclimate 1 'Very good' 2 'Good' 3 'Neither good nor poor' 4 'Poor' 5 'Very poor' -6 'Multi-coded' -8 'Do not know' -9 'Not answered'. missing values Eclimate (-9 to -6). exec . **************************************************************** . COMMENT Variable identifying how employee perceptions differ from employer (Eclimviews) . compute Eclimviews=-9. if mrelate=eclimate Eclimviews=3. if mrelate>eclimate Eclimviews=4. if mrelate>(eclimate+1) Eclimviews=5. if eclimate>mrelate Eclimviews=2. if eclimate>(mrelate+1) Eclimviews=1. if missing(mrelate) or missing(eclimate) Eclimviews=-9. missing values Eclimviews(-9). value labels Eclimviews 1 'employee rating worse by more than one point' 2 'employee rating worse by one point' 3 'manager and employee ratings same' 4 'manager rating worse by one point' 5 'manager rating worse by more than one point'. variable label Eclimviews 'employee and employer ratings of climate'. execute . **************************************************************** .