* TITLE 'WERS 98 DATA DISSEMINATION SERVICE' * SUBTITLE 'MQ98FIX.DO' * Purpose: Undertakes data edits described in MQNOTES Version 1.2 (Jan 2001) * Input file: Mq98fin.dta * Output file: None specified * Written by: Simon Kirby * Last updated: 30/01/01 * Version: v1.2 * Software: STATA version 6.0 * Need to set memory, e.g. "set mem 5000" * Syntax should be run once MQ98FIN data file has already been opened . ****************************************************** * Syntax from Version 1.1 of the Notes . ****************************************************** * Relabels and recodes missing values for CLONGHR #delimit ; recode clonghr .=8 if (serno==11425 | serno==11550 | serno==11556 | serno==11648 | serno==11727 | serno==11767 | serno==11856 | serno==11950 | serno==11992 | serno==12253 | serno==12522 | serno==13021 | serno==13034 | serno==13122 | serno==13228 | serno==13395 | serno==13550 | serno==13619 | serno==13642 | serno==13648 | serno==13650 | serno==13699 | serno==13737 | serno==14223 | serno==14256 | serno==14287 | serno==14339 | serno==14430 | serno==14455) ; #delimit cr label define clonghr 8 "8", modify label define clonghr 99 "Dont know", modify recode clonghr 99=. * Relabels and recodes missing values for CLONGDY #delimit ; recode clongdy .=8 if (serno==11808 | serno==11814 | serno==12144 | serno==12906 | serno==13252 | serno==13715 | serno==14133); recode clongdy .=9 if serno==12296 ; #delimit cr label define clongdy 8 "8", modify label define clongdy 9 "9", modify label define clongdy 98 "Not answered", modify label define clongdy 99 "Dont know", modify recode clongdy 98=. recode clongdy 99=. * Recodes missing values and relabels values for DOTHWAY1-5 recode dothway1 97=. recode dothway1 98=. recode dothway1 99=. label define dothway1 0 "None/ No", modify label define dothway1 1 "Through Managers", modify label define dothway1 2 "Suggestion schemes", modify label define dothway1 3 "Staff meetings/ committees", modify label define dothway1 4 "Staff representatives", modify label define dothway1 5 "Staff notices", modify label define dothway1 6 "Other specific answer, not codeable to 0-5", modify label define dothway1 97 "Other vague answer, not codeable to 0-6", modify label define dothway1 98 "Dont know", modify label define dothway1 99 "Not answered", modify label drop dothway2 dothway3 dothway4 dothway5 label values dothway2 dothway1 label values dothway3 dothway1 label values dothway4 dothway1 label values dothway5 dothway1 * Recodes case to missing for etotrec where total should not have been * calculated as euionum, eniona1 and erecog01 are all missing recode etotrec 0=. if serno==11990 * Recode EMOSTMEM in three cases recode emostmem 1=. if (serno==12080 | serno==12807 | serno==12871) ****************************************************** * Additions in Version 1.2 of the Notes ****************************************************** * Sets ZPRO_FPT to missing where values are 99999 or 99998 recode zpro_fpt 99999=. recode zpro_fpt 99998=. **************************************************** * Recodes missing values to zero for those cases identified in the work on the * EPQ data, i.e. where they are missing but the data adds up so variables * that are missing should actually read zero recode zmng_mft .=0 if serno==11005 recode zmng_mpt .=0 if serno==11005 recode zcle_mft .=0 if serno==11005 recode zcle_mpt .=0 if serno==11005 recode zcrt_mft .=0 if serno==11005 recode zcrt_mpt .=0 if serno==11005 recode zptc_mft .=0 if serno==11005 recode zptc_mpt .=0 if serno==11005 recode zsal_mft .=0 if serno==11005 recode zsal_mpt .=0 if serno==11005 recode zope_mft .=0 if serno==11005 recode zope_fft .=0 if serno==11005 recode zope_mpt .=0 if serno==11005 recode zope_fpt .=0 if serno==11005 recode zrou_mft .=0 if serno==11005 recode zrou_mpt .=0 if serno==11005 recode zmng_mpt .=0 if serno==11125 recode zpro_mpt .=0 if serno==11125 recode ztec_mpt .=0 if serno==11125 recode zcle_mpt .=0 if serno==11125 recode zcrt_mpt .=0 if serno==11125 recode zptc_mpt .=0 if serno==11125 recode zope_mpt .=0 if serno==11125 recode zrou_mpt .=0 if serno==11125 recode zcle_mft .=0 if serno==11337 recode zcle_fft .=0 if serno==11337 recode zmng_mpt .=0 if serno==11417 recode zmng_fpt .=0 if serno==11417 recode zcle_mpt .=0 if serno==11417 recode zcle_fpt .=0 if serno==11417 recode zcrt_mpt .=0 if serno==11417 recode zcrt_fpt .=0 if serno==11417 recode zptc_mft .=0 if serno==11417 recode zptc_fft .=0 if serno==11417 recode zptc_mpt .=0 if serno==11417 recode zptc_fpt .=0 if serno==11417 recode zsal_mft .=0 if serno==11417 recode zsal_fft .=0 if serno==11417 recode zsal_mpt .=0 if serno==11417 recode zsal_fpt .=0 if serno==11417 recode zrou_mpt .=0 if serno==11417 recode zrou_fpt .=0 if serno==11417 recode zmng_mft .=0 if serno==11581 recode zmng_mpt .=0 if serno==11581 recode zmng_fpt .=0 if serno==11581 recode zpro_mft .=0 if serno==11581 recode zpro_fft .=0 if serno==11581 recode zpro_mpt .=0 if serno==11581 recode zpro_fpt .=0 if serno==11581 recode zpro_tot .=0 if serno==11581 recode zcle_mft .=0 if serno==11581 recode zcle_fft .=0 if serno==11581 recode zcle_mpt .=0 if serno==11581 recode zcle_fpt .=0 if serno==11581 recode zcle_tot .=0 if serno==11581 recode zcrt_mft .=0 if serno==11581 recode zcrt_fft .=0 if serno==11581 recode zcrt_mpt .=0 if serno==11581 recode zcrt_fpt .=0 if serno==11581 recode zcrt_tot .=0 if serno==11581 recode zptc_mft .=0 if serno==11581 recode zptc_fft .=0 if serno==11581 recode zptc_mpt .=0 if serno==11581 recode zptc_fpt .=0 if serno==11581 recode zptc_tot .=0 if serno==11581 recode zsal_mft .=0 if serno==11581 recode zsal_fft .=0 if serno==11581 recode zsal_mpt .=0 if serno==11581 recode zsal_fpt .=0 if serno==11581 recode zsal_tot .=0 if serno==11581 recode zope_mft .=0 if serno==11581 recode zope_fft .=0 if serno==11581 recode zope_mpt .=0 if serno==11581 recode zope_fpt .=0 if serno==11581 recode zope_tot .=0 if serno==11581 recode zrou_mft .=0 if serno==11581 recode zrou_fft .=0 if serno==11581 recode zrou_mpt .=0 if serno==11581 recode zpro_mpt .=0 if serno==11590 recode zpro_fpt .=0 if serno==11590 recode zpro_tot .=0 if serno==11590 recode ztec_mpt .=0 if serno==11590 recode ztec_fpt .=0 if serno==11590 recode ztec_tot .=0 if serno==11590 recode zcrt_mpt .=0 if serno==11590 recode zcrt_fpt .=0 if serno==11590 recode zcrt_tot .=0 if serno==11590 recode zptc_mpt .=0 if serno==11590 recode zptc_fpt .=0 if serno==11590 recode zptc_tot .=0 if serno==11590 recode zsal_mpt .=0 if serno==11590 recode zsal_fpt .=0 if serno==11590 recode zsal_tot .=0 if serno==11590 recode zope_mpt .=0 if serno==11590 recode zope_fpt .=0 if serno==11590 recode zope_tot .=0 if serno==11590 recode zmng_mpt .=0 if serno==11703 recode zpro_mpt .=0 if serno==11703 recode ztec_mpt .=0 if serno==11703 recode zcle_mpt .=0 if serno==11703 recode zcrt_mpt .=0 if serno==11703 recode zope_mpt .=0 if serno==11703 recode zrou_mpt .=0 if serno==11703 recode ztec_mft .=0 if serno==12009 recode ztec_fft .=0 if serno==12009 recode ztec_mpt .=0 if serno==12009 recode ztec_fpt .=0 if serno==12009 recode zptc_mpt .=0 if serno==12009 recode zptc_fpt .=0 if serno==12009 recode zope_mft .=0 if serno==12009 recode zope_fft .=0 if serno==12009 recode zope_mpt .=0 if serno==12009 recode zope_fpt .=0 if serno==12009 recode zsal_tot .=0 if serno==12902 recode zope_tot .=0 if serno==12902 recode ztec_fpt .=0 if serno==12911 recode zcle_mpt .=0 if serno==12911 recode zcle_fpt .=0 if serno==12911 recode zcrt_fpt .=0 if serno==12911 recode zsal_mpt .=0 if serno==12911 recode zsal_fpt .=0 if serno==12911 recode zope_fpt .=0 if serno==12911 recode zpro_tot .=0 if serno==12763 recode ztec_tot .=0 if serno==12763 recode zcrt_tot .=0 if serno==12763 recode zptc_tot .=0 if serno==12763 recode zrou_tot .=0 if serno==12763 recode zmng_mft .=0 if serno==12881 recode zmng_mpt .=0 if serno==12881 recode zmng_fpt .=0 if serno==12881 recode ztec_mpt .=0 if serno==12883 recode zcrt_mpt .=0 if serno==12883 recode zope_mpt .=0 if serno==12883 recode zcrt_tot .=0 if serno==12902 recode zrou_tot .=0 if serno==12902 recode zmng_mpt .=0 if serno==12911 recode zmng_fpt .=0 if serno==12911 recode zpro_mpt .=0 if serno==12911 recode zpro_fpt .=0 if serno==12911 recode ztec_mpt .=0 if serno==12911 recode zcrt_mpt .=0 if serno==12911 recode zope_mpt .=0 if serno==12911 recode zmng_mft .=0 if serno==13231 recode zmng_fft .=0 if serno==13231 recode zmng_mpt .=0 if serno==13231 recode zmng_fpt .=0 if serno==13231 recode zpro_mft .=0 if serno==13231 recode zpro_fft .=0 if serno==13231 recode zpro_mpt .=0 if serno==13231 recode zpro_fpt .=0 if serno==13231 recode ztec_mft .=0 if serno==13231 recode ztec_fft .=0 if serno==13231 recode ztec_mpt .=0 if serno==13231 recode ztec_fpt .=0 if serno==13231 recode zcrt_mft .=0 if serno==13231 recode zcrt_fft .=0 if serno==13231 recode zcrt_mpt .=0 if serno==13231 recode zcrt_fpt .=0 if serno==13231 recode zptc_mft .=0 if serno==13231 recode zptc_fft .=0 if serno==13231 recode zptc_mpt .=0 if serno==13231 recode zptc_fpt .=0 if serno==13231 recode zsal_mft .=0 if serno==13231 recode zsal_fft .=0 if serno==13231 recode zsal_mpt .=0 if serno==13231 recode zsal_fpt .=0 if serno==13231 recode zope_mft .=0 if serno==13231 recode zope_fft .=0 if serno==13231 recode zope_mpt .=0 if serno==13231 recode zope_fpt .=0 if serno==13231 recode zrou_mft .=0 if serno==13231 recode zrou_fft .=0 if serno==13231 recode zrou_mpt .=0 if serno==13231 recode zrou_fpt .=0 if serno==13231 recode zmng_mpt .=0 if serno==13308 recode zmng_fpt .=0 if serno==13308 recode zpro_mpt .=0 if serno==13308 recode zpro_fpt .=0 if serno==13308 recode zcle_mpt .=0 if serno==13308 recode zcle_fpt .=0 if serno==13308 recode zcrt_mpt .=0 if serno==13308 recode zcrt_fpt .=0 if serno==13308 recode zptc_mpt .=0 if serno==13308 recode zptc_fpt .=0 if serno==13308 recode zsal_mpt .=0 if serno==13308 recode zsal_fpt .=0 if serno==13308 recode zope_mpt .=0 if serno==13308 recode zope_fpt .=0 if serno==13308 recode zrou_mpt .=0 if serno==13308 recode zrou_fpt .=0 if serno==13308 recode zptc_mft .=0 if serno==13341 recode zptc_fft .=0 if serno==13341 recode zptc_mpt .=0 if serno==13341 recode zptc_fpt .=0 if serno==13341 recode zsal_mft .=0 if serno==13341 recode zsal_fft .=0 if serno==13341 recode zsal_mpt .=0 if serno==13341 recode zsal_fpt .=0 if serno==13341 recode zope_mft .=0 if serno==13341 recode zope_fft .=0 if serno==13341 recode zope_mpt .=0 if serno==13341 recode zope_fpt .=0 if serno==13341 **************************************************** * Sets ADDRESS2 to missing where the value is 9 recode address2 9=. * Sets CLASSIF to missing where value is 97 (refers to 'Lots but dont know how many') recode classif 97=. * Adds two missing value labels for EUNIONA1-EUNIOA10 and sets to missing values of 999 recode euniona1 999=. label define euniona1 42 "ASTMS", modify label define euniona1 58 "CLEARING BANK UNION", modify label define euniona2 42 "ASTMS", modify label define euniona2 58 "CLEARING BANK UNION", modify label define euniona3 42 "ASTMS", modify label define euniona3 58 "CLEARING BANK UNION", modify label define euniona4 42 "ASTMS", modify label define euniona4 58 "CLEARING BANK UNION", modify label define euniona5 42 "ASTMS", modify label define euniona5 58 "CLEARING BANK UNION", modify label define euniona6 42 "ASTMS", modify label define euniona6 58 "CLEARING BANK UNION", modify label define euniona7 42 "ASTMS", modify label define euniona7 58 "CLEARING BANK UNION", modify label define euniona8 42 "ASTMS", modify label define euniona8 58 "CLEARING BANK UNION", modify label define euniona9 42 "ASTMS", modify label define euniona9 58 "CLEARING BANK UNION", modify label define eunioa10 42 "ASTMS", modify label define eunioa10 58 "CLEARING BANK UNION", modify * Sets missing values that have not been set for FPAYCHGE recode fpaychge 999.8=. recode fpaychge 999.9=. * Recodes the blank case in FTYPEAP7 recode ftypeap7 8=5 * labels the variables HRESOLV1 - 2 label variable hresolv1 "If an employee has a problem with some aspect of their working conditions, how do they resolve it?" label variable hresolv2 "If an employee has a problem with some aspect of their working conditions, how do they resolve it?" * Sets missing value that has not been set for IPATERN recode ipatern 97=. * Sets missing value that has not been set for JDURATIO recode jduratio 97=. * Sets missing value that has not been set for MQLOC recode mqloc 9=.