************************************************. COMMENT Derived variables for WERS 2004 Cross-Section Survey of Managers . COMMENT Variables created by WERS Research Team . COMMENT Syntax made publicly available by WERS Information and Advice Service (www.wers2004.info) . COMMENT Version 1.1 (11th May 2006) . COMMENT Run syntax on deposited SPSS data file (XS04_MQ.sav) . ************************************************. COMMENT List of derived variables created in this syntax file (listed in order) . ** Flag to indicate whether components of EPQ Qn 3 (Occ grid) sum correctly (Nocc_flg). ** The largest occupational group (LOG) as identified on the EPQ (Nhiocc). ** Proportion of employees in the largest occupational group (Nhioccp) . ** Proportion of non-managerial employees with supervisory responsibilities (Ninvman2). ** Proportion of LOG trained to be functionally flexible (Nothjob) ** Functional flexibility in practice (Nothdo) . ** Percentage of employees who use computers (Ncomput) . ** Proportion of LOG working in teams (Nteams) . ** Proportion of non-managerials participating in problem-solving groups in last 12 months (Npropor) . ** Number of unions with members at the workplace (Nunions). ** Percentage of non-managerial employees in receipt of payment by results/merit pay (Nmerpbrnon) . ** Percentage of non-managerial employees in receipt of profit related pay (Nfprpnon) . ** Proportion of non-managerial employees eligible for Employee Share Ownership Scheme (Nfshanon) . ** Proportion of employees covered by largest job evaluation scheme (Nfjobpro) . ** Collective bargaining coverage, all employees (Nfcover) . ** Proportion of non-managerial employees having their performance formally appraised (Nfmeaspr) . ** Proportion of non-managerial employees covered by formal collective disputes procedure (Ngcoverd) . ** Proportion of LOG regularly working overtime (Noverti2) . ** Proportion of managerial employees regularly working more than 48 hours a week (Nman48b) . ** Proportion of non-managerial employees regularly working more than 48 hours a week (Nnman48b) . ******************************************************************************** . COMMENT Derived variable syntax follows in the order indicated above. ******************************************************************************** . COMMENT Flag to indicate whether components of EPQ Qn 3 (Occ grid) sum correctly (Nocc_flg). Numeric Nocc_flg (f1.0) . compute Nocc_flg=(sum(zmng_tot,zpro_tot,ztec_tot,zadm_tot,zskl_tot,zper_tot,zsal_tot,zope_tot,zrou_tot,0)=zallemps)=0. variable labels Nocc_flg "Flag: occupational totals do not sum to Zallemps" . value labels Nocc_flg 1 "Totals do not sum to Zallemps" 0 "Occ totals = zallemps" . ******************************************************************************** COMMENT Variables to identify the largest occupational group (LOG) (Nhiocc, Nhioccp) . Numeric hiocc1 (F5.0). do if (missing(zpro_tot) = 1 | missing(ztec_tot) = 1 | missing(zadm_tot) = 1 | missing(zskl_tot) = 1 | missing(zper_tot) = 1 | missing(zsal_tot) = 1 | missing(zope_tot) = 1 | missing(zrou_tot) = 1). + compute hiocc1 = -9. else. + compute hiocc1 = max(zpro_tot, ztec_tot, zadm_tot, zskl_tot, zper_tot, zsal_tot, zope_tot, zrou_tot). end if. execute. missing values hiocc1 (-9). Numeric Nhiocc (F3.0). do if (hiocc1 = 0 | missing(hiocc1) = 1). + compute Nhiocc = -9. end if. execute. do if (hiocc1 = zrou_tot). + recode Nhiocc (sysmis = 9). else if (hiocc1 = zope_tot). + recode Nhiocc (sysmis = 8). else if (hiocc1 = zsal_tot). + recode Nhiocc (sysmis = 7). else if (hiocc1 = zper_tot). + recode Nhiocc (sysmis = 6). else if (hiocc1 = zskl_tot). + recode Nhiocc (sysmis = 5). else if (hiocc1 = zadm_tot). + recode Nhiocc (sysmis = 4). else if (hiocc1 = ztec_tot). + recode Nhiocc (sysmis = 3). else if (hiocc1 = zpro_tot). + recode Nhiocc (sysmis = 2). end if. execute. variable labels Nhiocc 'Non-managerial occupational group with the most employees'. value labels Nhiocc 1 'Managers and senior officials' 2 'Professional' 3 'Associate professional and technical' 4 'Administrative and secretarial' 5 'Skilled trades' 6 'Caring, leisure and personal service' 7 'Sales' 8 'Operative and assembly' 9 'Routine unskilled' -8 'LOG questions asked of wrong group' -9 'Do not know / Not answered'. missing values Nhiocc (-8,-9). delete variable hiocc1 * Proportion of employment accounted for by the largest occupational group (NHIOCCP)(All employees as base). Numeric Nhioccp (F3.2). do if (missing(Nhiocc) = 1 or Nocc_flg=1). + compute Nhioccp = -9. else if (Nhiocc = 1). + compute Nhioccp = zmng_tot / zallemps. else if (Nhiocc = 2). + compute Nhioccp = zpro_tot / zallemps. else if (Nhiocc = 3). + compute Nhioccp = ztec_tot / zallemps. else if (Nhiocc = 4). + compute Nhioccp = zadm_tot / zallemps. else if (Nhiocc = 5). + compute Nhioccp = zskl_tot / zallemps. else if (Nhiocc = 6). + compute Nhioccp = zper_tot / zallemps. else if (Nhiocc = 7). + compute Nhioccp = zsal_tot / zallemps. else if (Nhiocc = 8). + compute Nhioccp = zope_tot / zallemps. else if (Nhiocc = 9). + compute Nhioccp = zrou_tot / zallemps. end if. missing values Nhioccp (-9). variable label Nhioccp 'Largest non-mangerial occupational group as a proportion of all employees'. value labels Nhioccp -9 'Missing data/Numbers do not sum'. execute. ******************************************************************************** COMMENT Variables to recode 97s back into 'workforce proportions' code frames. ******************************************************************************** COMMENT Proportion of non-managerial employees with supervisory responsibilities (Ninvman2) . COMMENT Combines responses from variables BINVMANG and BINVMANT. Numeric Ninvman2 (F5.0). do if missing(binvmang) | (missing (binvmang) = 0 & binvmang<97). + recode binvmang (else=copy) into Ninvman2 . else if missing(binvmang)=0 & binvmang = 97 . + do if nocc_flg=0 . + compute temp=(binvmant/sum.2(zallemps,-zmng_tot))*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into Ninvman2 . + else if nocc_flg=1 . + compute ninvman2=-8 . + end if . end if . value labels Ninvman2 1 'All' 2 'Almost all' 3 'Most' 4 'Around half' 5 'Some' 6 'Just a few' 7 'None' -8 'DK' -9 'NA' -1 'Not applicable'. variable labels Ninvman2 'Proportion of non-mangerial employees with supervisory responsibilities'. missing values Ninvman2 (-8,-9,-1). exec . delete variables temp . ******************************************************************************** COMMENT Proportion of LOG trained to be functionally flexible (Nothjob) . COMMENT Combines responses from variables COTHJOB and COTHJOBT. numeric Nothjob (f3). do if missing(cothjob) or (missing(cothjob)=0 and cothjob<97). + recode cothjob (else=copy) into nothjob . else if missing(cothjob)=0 and cothjob=97 . + do if missing(nhioccp) . + compute nothjob=-7 . + else . + compute temp=(cothjobt*100)/(nhioccp*zallemps) . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) into nothjob . + end if . end if . missing values nothjob (-9 thru -1) . variable labels nothjob "Proportion of LOG trained to be functionally flexible" . value labels nothjob 1 "All (100%)" 2 "Almost all (80-99%)" 3 "Most (60-79%)" 4 "Around half (40-59%)" 5 "Some (20-39%)" 6 "Just a few (1-19%)" 7 "None (0%)" -7 "Nhioccp missing" -8 "DK" -9 "NA" . execute . delete variable temp. ******************************************************************************** COMMENT Functional flexibility in practice (Nothdo) . COMMENT Combines responses from variables COTHDO and COTHDOT. numeric Nothdo (f3). do if missing(cothdo) or (missing(cothdo)=0 and cothdo<97). + recode cothdo (else=copy) into nothdo . else if missing(cothdo)=0 and cothdo=97 . + do if missing(nhioccp) . + compute nothdo=-7 . + else . + compute temp=(cothdot*100)/(nhioccp*zallemps) . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) into nothdo . + end if . end if . missing values nothdo (-9 thru -1) . variable labels nothdo "Proportion of LOG being functionally flexible at least once a week" . value labels nothdo 1 "All (100%)" 2 "Almost all (80-99%)" 3 "Most (60-79%)" 4 "Around half (40-59%)" 5 "Some (20-39%)" 6 "Just a few (1-19%)" 7 "None (0%)" -7 "Nhioccp missing" -8 "DK" -9 "NA" . execute . delete variable temp . ******************************************************************************** COMMENT Percentage of employees who use computers (Ncomput) . COMMENT Combines responses from variables CCOMPUT and CCOMPUTT. * Note: there are a few cases where, because of check error early in fieldwork, could not enter 100% at ccomput, * so put 100 in ccomputt. These are dealt with by 'min' statement, which takes all values of 100 in ccomputt as meaning 100% . Numeric Ncomput (f8.2) . do if missing (ccomput) . + recode ccomput (else=copy) into Ncomput . else if missing(ccomput)=0 and ccomput<=100 . + compute Ncomput=ccomput . else if missing(ccomput)=0 and ccomput=997 . + compute ncomput=min.2(((ccomputt*100)/zallemps),100) . end if . missing values ncomput (-9, -8) . variable labels ncomput "Percentage of employees who use computers" . value labels ncomput -8 "DK" -9 "NA" . execute . ******************************************************************************** COMMENT Proportion of LOG working in teams (Nteams) . COMMENT Combines responses from variables CTEAMS and CTEAMST. numeric Nteams (f3). do if missing(cteams) or (missing(cteams)=0 and cteams<97). + recode cteams (else=copy) into nteams . else if missing(cteams)=0 and cteams=97 . + do if missing(nhioccp) . + compute nteams=-7 . + else . + compute temp=(cteamst*100)/(nhioccp*zallemps) . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) into nteams . + end if . end if . missing values nteams (-9 thru -1) . variable labels nteams "Proportion of LOG that works in teams" . value labels nteams 1 "All (100%)" 2 "Almost all (80-99%)" 3 "Most (60-79%)" 4 "Around half (40-59%)" 5 "Some (20-39%)" 6 "Just a few (1-19%)" 7 "None (0%)" -7 "Nhioccp missing" -8 "DK" -9 "NA" . execute . delete variable temp . ****************************************************************************************** COMMENT Proportion of non-managerials involved in problem-solving groups in last 12 months (Npropor) . COMMENT Combines responses from variables DPROPOR and DPROPORT. numeric Npropor (f2.0) . do if missing(dpropor) or (missing(dpropor)=0 and dpropor<97). + recode dpropor (else=copy) into npropor . else if missing(dpropor)=0 and dpropor=97 . + do if nocc_flg=0 . + compute temp=(dproport/sum.2(zallemps,-zmng_tot))*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into Npropor . + else if nocc_flg=1 . + compute npropor=-8 . + end if . end if . missing values npropor (-9 thru -1) . variable labels npropor "Proportion of non-managerials involved in problem-solving groups in past 12 months" . value labels npropor 1 "All (100%)" 2 "Almost all (80-99%)" 3 "Most (60-79%)" 4 "Around half (40-59%)" 5 "Some (20-39%)" 6 "Just a few (1-19%)" 7 "None (0%)" -1 "Not applicable: no problem-solving groups" -7 "Nnmp missing" -8 "DK" -9 "NA" . exec . delete variable temp . ****************************************************************************************** COMMENT Number of unions with members at the workplace (Nunions) . COMMENT Combines responses from variables EUNIONUM and EUNIONCK. Numeric Nunions (f2). do if missing(eunionum) or (missing(eunionum)=0 and eunionum<10) . + recode eunionum (else=copy) into Nunions . else if (missing(eunionum)=0 and eunionum=10) . + recode eunionck (else=copy) into Nunions . end if . missing values Nunions (-1,-8,-9). variable labels Nunions 'Number of unions with members at the workplace'. value labels Nunions -1 "Not applicable" -8 'DK' -9 'Not answered'. execute. *********************************************************************************************** COMMENT Percentage of NON-MANAGERIAL employees receiving PBR or merit pay (Nmerpbrnon) . COMMENT Combines responses from variables FPERNON and FPERNONT. Numeric Nmerpbrnon (f2.0) . do if missing(fpernon) or (missing(fpernon)=0 and fpernon<97). + recode fpernon (else=copy) into Nmerpbrnon . else if missing(fpernon)=0 and fpernon=97 . + do if nocc_flg=0 . + compute temp=(fpernont/sum.2(zallemps,-zmng_tot))*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into Nmerpbrnon . + else if nocc_flg=1 . + compute Nmerpbrnon=-8 . + end if . end if . missing values Nmerpbrnon (-9 to -1). value labels Nmerpbrnon 1 '100%' 2 '80-99%' 3 '60-79%' 4 '40-59%' 5 '20-39%' 6 '1-19%' 7 'None' -1 'Not applicable' -8 'DK' -9 'Refused'. variable label Nmerpbrnon "Percentage of non-managerial employees getting PBR or merit pay". exec. delete variable temp . *********************************************************************************************** COMMENT Percentage of NON-MANAGERIAL employees receiving profit-related payments in last 12 months (Nfprpnon) . COMMENT Combines responses from variables FNONMAN and FNONMANT. numeric Nfprpnon (f2.0) . do if missing(fnonman) or (missing(fnonman)=0 and fnonman<97). + recode fnonman (else=copy) into nfprpnon . else if missing(fnonman)=0 and fnonman=97 . + do if nocc_flg=0 . + compute temp=(fnonmant/sum.2(zallemps,-zmng_tot))*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into nfprpnon . + else if nocc_flg=1 . + compute nfprpnon=-8 . + end if . end if . missing values nfprpnon (-9 to -1). value labels nfprpnon 1 '100%' 2 '80-99%' 3 '60-79%' 4 '40-59%' 5 '20-39%' 6 '1-19%' 7 'None' -1 'Not applicable' -8 'DK' -9 'Refused'. variable label nfprpnon "Percentage of non-managerial employees getting profit-related pay in last 12 months". exec . delete variables temp . *********************************************************************************************** COMMENT Percentage of NON-MANAGERIAL employees eligible for share ownership schemes (Nfshanon) . COMMENT Combines responses from variables FSHARWHO and FSHARWHT. Numeric Nfshanon (f2.0) . do if missing(fsharwho) or (missing(fsharwho)=0 and fsharwho<97). + recode fsharwho (else=copy) into nfshanon . else if missing(fsharwho)=0 and fsharwho=97 . + do if nocc_flg=0 . + compute temp=(fsharwht/sum.2(zallemps,-zmng_tot))*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into nfshanon . + else if nocc_flg=1 . + compute nfshanon=-8 . + end if . end if . missing values nfshanon (-9 to -1). value labels nfshanon 1 '100%' 2 '80-99%' 3 '60-79%' 4 '40-59%' 5 '20-39%' 6 '1-19%' 7 'None' -1 'Not applicable' -8 'DK' -9 'Refused'. variable label nfshanon "Percentage of non-managerial employees eligible for ESOPs". exec . delete variables temp . *********************************************************************************************** COMMENT Proportion of employees covered by largest job evaluation scheme (Nfjobpro) . COMMENT Combines responses from variables FJOBPROP and FJOBPROT. Numeric Nfjobpro (f2.0) . do if missing(fjobprop) or (missing(fjobprop)=0 and fjobprop<97). + recode fjobprop (else=copy) into nfjobpro . else if missing(fjobprop)=0 and fjobprop=97 . + compute temp=(fjobprot/zallemps)*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into nfjobpro . end if . variable labels nfjobpro 'Proportion of employees currently in jobs covered by the largest job evaluation scheme'. value labels nfjobpro 1 'All (100%)' 2 'Almost all (80-99%)' 3 'Most (60-79%)' 4 'Around half (40-59%)' 5 'Some (20-39%)' 6 'Just a few (1-19%)' 7 'None (0%)' -1 'Not applicable' -8 'Dont know' -9 'Not answered'. execute. missing values Nfjobpro (-1, -8, -9). delete variables temp . *********************************************************************************************** COMMENT Proportion of all employees here whose pay is set through negotiations with trade unions (Nfcover) COMMENT Combines responses from variables FCOVER and FCOVERT. Numeric Nfcover (f2.0) . do if missing(fcover) or (missing(fcover)=0 and fcover<97). + recode fcover (else=copy) into nfcover . else if missing(fcover)=0 and fcover=97 . + compute temp=(fcovert/zallemps)*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into nfcover . end if . missing values nfcover (-8,-9). value labels nfcover 1 '100%' 2 '80-99%' 3 '60-79%' 4 '40-59%' 5 '20-39%' 6 '1-19%' 7 'None' -8 'DK,NA'. variable label nfcover "Proportion of all employees here whose pay is set through negotiations with trade unions". exec. delete variables temp . *********************************************************************************************** COMMENT Proportion of non-managerial employees having their performance formally appraised (Nfmeaspr) . COMMENT Combines responses from variables FMEASPR and FMEASPRT. numeric Nfmeaspr (f2.0) . do if missing(fmeaspr) or (missing(fmeaspr)=0 and fmeaspr<97). + recode fmeaspr (else=copy) into nfmeaspr . else if missing(fmeaspr)=0 and fmeaspr=97 . + do if nocc_flg=0 . + compute temp=(fmeasprt/sum.2(zallemps,-zmng_tot))*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into nfmeaspr . + else if nocc_flg=1 . + compute nfmeaspr=-8 . + end if . end if . missing values nfmeaspr (-9 thru -1) . variable labels nfmeaspr "Proportion of non-managerial employees who have their performance formally appraised" . value labels nfmeaspr 1 "All (100%)" 2 "Almost all (80-99%)" 3 "Most (60-79%)" 4 "Around half (40-59%)" 5 "Some (20-39%)" 6 "Just a few (1-19%)" -1 "Not applicable" -7 "Nnmp missing" -8 "DK" . exec . delete variable temp . ************************************************************************************************** COMMENT Proportion of non-managerial employees covered by the formal collective disputes procedure (ngcoverd) . COMMENT Combines responses from variables GCOVERED and GCOVERET. Numeric Ngcoverd (f2.0) . do if missing(gcovered) or (missing(gcovered)=0 and gcovered<97). + recode gcovered (else=copy) into Ngcoverd . else if missing(gcovered)=0 and gcovered=97 . + do if nocc_flg=0 . + compute temp=(gcoveret/sum.2(zallemps,-zmng_tot))*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into Ngcoverd . + else if nocc_flg=1 . + compute Ngcoverd=-8 . + end if . end if . variable labels ngcoverd 'Proportion of non-mangerials covered by dispute procedure'. value labels ngcoverd 1 'All (100%)' 2 'Almost all (80-99%)' 3 'Most (60-79%)' 4 'Around half (40-59%)' 5 'Some (20-39%)' 6 'Just a few (1-19%)' 7 'None (0%)' -1 'Not applicable' -8 'Dont know' -9 'Not answered'. missing values ngcoverd (-1, -8, -9). execute. delete variables temp . ****************************************************************************************************** COMMENT Proportion of LOG regularly working overtime (noverti2) . COMMENT Combines responses from variables JOVERTIM and JOVERTIT. numeric Noverti2 (f2.0) . do if missing(jovertim) or (missing(jovertim)=0 and jovertim<97). + recode jovertim (else=copy) into noverti2 . else if missing(jovertim)=0 and jovertim=97 . + do if missing(nhioccp) . + compute noverti2=-7 . + else . + compute temp=(jovertit*100)/(nhioccp*zallemps) . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) into noverti2 . + end if . end if . variable labels noverti2 "Proportion of LOG regularly working overtime". value labels noverti2 1 "All (100%)" 2 "Almost all (80-99%)" 3 "Most (60-79%)" 4 "Around half (40-59%)" 5 "Some (20-39%)" 6 "Just a few (1-19%)" 7 "None (0%)" -1 "Not applicable" -8 "Do not know" -9 "Refused". missing values noverti2 (-1, -8, -9). exec . delete variables temp . ****************************************************************************************************** COMMENT Proportion of managerial employees regularly working more than 48 hours a week (nman48b) . COMMENT Combines responses from variables JEXHMAN and JEXHMANT. numeric Nman48b (f3.0). do if missing(jexhman) or (missing(jexhman)=0 and jexhman<97). + recode jexhman (else=copy) into nman48b . else if missing(jexhman)=0 and jexhman=97 . + do if nocc_flg=0 . + compute temp=(jexhmant/zmng_tot)*100 . + recode temp (0=7) (100 thru hi=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into nman48b . + else if nocc_flg=1 . + compute nman48b=-8 . + end if . end if . variable labels nman48b "Proportion of managers regularly working in excess of 48 hours a week". value labels nman48b 1 "All (100%)" 2 "Almost all (80-99%)" 3 "Most (60-79%)" 4 "Around half (40-59%)" 5 "Some (20-39%)" 6 "Just a few (1-19%)" 7 "None (0%)" -1 "Not applicable" -8 "Do not know" -9 "Refused". missing values nman48b (-1, -8, -9). exec . delete variable temp . ****************************************************************************************************** COMMENT Proportion of non managerial employees regularly working more than 48 hours a week (nnman48b) . COMMENT Combines responses from variables JEXHNMAN and JEXHNMT. Numeric Nnman48b (f2.0) . do if missing(jexhnman) | (missing (jexhnman) = 0 & jexhnman<97). + recode jexhnman (else=copy) into nnman48b . else if missing(jexhnman)=0 & jexhnman = 97 . + do if nocc_flg=0 . + compute temp=(jexhnmt/sum.2(zallemps,-zmng_tot))*100 . + recode temp (0=7) (100=1) (79.5 thru 100=2) (59.5 thru 79.5=3) (39.5 thru 59.5=4) (19.5 thru 39.5=5) (0 thru 19.5=6) (sysmis=-8) into nnman48b . + else if nocc_flg=1 . + compute nnman48b=-8 . + end if . end if . variable labels nnman48b "Proportion of non-managerial employees regularly working in excess of 48 hours a week". value labels nnman48b 1 "All (100%)" 2 "Almost all (80-99%)" 3 "Most (60-79%)" 4 "Around half (40-59%)" 5 "Some (20-39%)" 6 "Just a few (1-19%)" 7 "None (0%)" -1 "Not applicable" -8 "Do not know" -9 "Refused". missing values nnman48b (-1, -8, -9). exec . delete variables temp .