************************************************** . * * SPSS syntax to construct a 1998-2004 panel dataset in wide or long form . * Version 1.2 (23/01/08) . * Revised following release of Version 3 of the 2004 panel data file . * * Requires SPSS version 12.0 or later, as it creates some variables with names of 9+ characters. * * Compiled by WERS 2004 Information and Advice Service (www.wers2004.info) . * ************************************************** . * Construct a panel dataset in wide form . * Notes: * 1. Variables containing 1998 data are prefixed with the letter X; those containing 2004 data are prefixed with the letter Y. * 2. The 2004 variables Xsample, Xoutcome, Xout3 and Xemps2004 are renamed to Ysample, Youtcome, Yout3 and Yemps2004 . * 3. Other variables already beginning with the letter 'x' receive the X or Y prefix as appropriate, e.g. Xxcode1, Yxcode1, Yxbtitle . * 4. The unique workplace id (serno) and the weighting variables from the 2004 data file (estwtnr, empwtnr, pqwtnr) do not receive a prefix . * 5. The original 1998 weight variables (est_wt, grosswt and emp_wt) are dropped since they have been superceded by estwtnr and empwtnr . * 6. Missing values in 1998 are recoded so that missings on almost all variables are consistently coded to -1 (Not answered) and -9 (DK/NA) . ************************************************** . * Step 1: Read in (and fix) 1998 data, link files, add prefixes and drop unwanted variables . get file="C:\your_path\MQ98FIN.SAV" . include "C:\your_path\MQ98FIX.SPS" . variable labels btitle2 "Job title of main management respondent (coded from verbatim)" . match files file=* /rename (xcode1=Xxcode1) (xcode2=Xxcode2) (xcode3=Xxcode3) (xcode4=Xxcode4) (xcode5=Xxcode5) (zallemps=Xzallemps) (zmalfull=Xzmalfull) (zfemfull=Xzfemfull) (zmalprt=Xzmalprt) (zfemprt=Xzfemprt) (ztotmen=Xztotmen) (ztotwom=Xztotwom) (zallpte=Xzallpte) (zallfte=Xzallfte) (zmng_mft=Xzmng_mft) (zmng_fft=Xzmng_fft) (zmng_mpt=Xzmng_mpt) (zmng_fpt=Xzmng_fpt) (zmng_tot=Xzmng_tot) (zpro_mft=Xzpro_mft) (zpro_fft=Xzpro_fft) (zpro_mpt=Xzpro_mpt) (zpro_fpt=Xzpro_fpt) (zpro_tot=Xzpro_tot) (ztec_mft=Xztec_mft) (ztec_fft=Xztec_fft) (ztec_mpt=Xztec_mpt) (ztec_fpt=Xztec_fpt) (ztec_tot=Xztec_tot) (zcle_mft=Xzcle_mft) (zcle_fft=Xzcle_fft) (zcle_mpt=Xzcle_mpt) (zcle_fpt=Xzcle_fpt) (zcle_tot=Xzcle_tot) (zcrt_mft=Xzcrt_mft) (zcrt_fft=Xzcrt_fft) (zcrt_mpt=Xzcrt_mpt) (zcrt_fpt=Xzcrt_fpt) (zcrt_tot=Xzcrt_tot) (zptc_mft=Xzptc_mft) (zptc_fft=Xzptc_fft) (zptc_mpt=Xzptc_mpt) (zptc_fpt=Xzptc_fpt) (zptc_tot=Xzptc_tot) (zsal_mft=Xzsal_mft) (zsal_fft=Xzsal_fft) (zsal_mpt=Xzsal_mpt) (zsal_fpt=Xzsal_fpt) (zsal_tot=Xzsal_tot) (zope_mft=Xzope_mft) (zope_fft=Xzope_fft) (zope_mpt=Xzope_mpt) (zope_fpt=Xzope_fpt) (zope_tot=Xzope_tot) (zrou_mft=Xzrou_mft) (zrou_fft=Xzrou_fft) (zrou_mpt=Xzrou_mpt) (zrou_fpt=Xzrou_fpt) (zrou_tot=Xzrou_tot) (zemp1ago=Xzemp1ago) (zemp5ago=Xzemp5ago) (zresigne=Xzresigne) (zdismiss=Xzdismiss) (zredund=Xzredund) (zother=Xzother) (zcommwor=Xzcommwor) (zund20=Xzund20) (zund20pc=Xzund20pc) (zover51=Xzover51) (zover51p=Xzover51p) (zdisab=Xzdisab) (zdisabpc=Xzdisabpc) (zethnic=Xzethnic) (zethnicp=Xzethnicp) (zabsence=Xzabsence) (ztu_mem=Xztu_mem) (ztu_pc=Xztu_pc) (zanymem=Xzanymem) (zwgft350=Xzwgft350) (zwgft400=Xzwgft400) (zwgpt350=Xzwgpt350) (zwgpt400=Xzwgpt400) (zmftlt9=Xzmftlt9) (zfftlt9=Xzfftlt9) (ztftlt9=Xztftlt9) (zmftlt12=Xzmftlt12) (zfftlt12=Xzfftlt12) (ztftlt12=Xztftlt12) (zmftlt16=Xzmftlt16) (zfftlt16=Xzfftlt16) (ztftlt16=Xztftlt16) (zmftlt22=Xzmftlt22) (zfftlt22=Xzfftlt22) (ztftlt22=Xztftlt22) (zmftlt29=Xzmftlt29) (zfftlt29=Xzfftlt29) (ztftlt29=Xztftlt29) (zmftmt29=Xzmftmt29) (zfftmt29=Xzfftmt29) (ztftmt29=Xztftmt29) (zscode=Xzscode) (asic=Xasic) (asicprod=Xasicprod) (asingle=Xasingle) (aestnum=Xaestnum) (auktot=Xauktot) (astatus=Xastatus) (afranch=Xafranch) (aconint=Xaconint) (aownman=Xaownman) (acontrol=Xacontrol) (aconhead=Xaconhead) (aheadoff=Xaheadoff) (asubsid=Xasubsid) (ahowlong=Xahowlong) (address2=Xaddress2) (aprev5yr=Xaprev5yr) (aprev=Xaprev) (aownchan=Xaownchan) (ahowcha1=Xahowcha1) (ahowcha2=Xahowcha2) (ahowcha3=Xahowcha3) (aphras01=Xaphras01) (aphras02=Xaphras02) (aphras03=Xaphras03) (aphras04=Xaphras04) (aphras05=Xaphras05) (aphras06=Xaphras06) (aphras07=Xaphras07) (aphras08=Xaphras08) (aphras09=Xaphras09) (aphras10=Xaphras10) (alongdev=Xalongdev) (bsex=Xbsex) (btitle2=Xbtitle2) (byourj01=Xbyourj01) (byourj02=Xbyourj02) (byourj03=Xbyourj03) (byourj04=Xbyourj04) (byourj05=Xbyourj05) (byourj06=Xbyourj06) (byourj07=Xbyourj07) (byourj08=Xbyourj08) (byourj09=Xbyourj09) (bumanage=Xbumanage) (brelate=Xbrelate) (bproport=Xbproport) (blength=Xblength) (bservice=Xbservice) (bhavqual=Xbhavqual) (bassist=Xbassist) (binvmang=Xbinvmang) (blinej01=Xblinej01) (blinej02=Xblinej02) (blinej03=Xblinej03) (blinej04=Xblinej04) (blinej05=Xblinej05) (blinej06=Xblinej06) (blinej07=Xblinej07) (blinej08=Xblinej08) (blinej09=Xblinej09) (bauthor1=Xbauthor1) (bauthor2=Xbauthor2) (bauthor3=Xbauthor3) (bsuptrai=Xbsuptrai) (bsepar=Xbsepar) (bboard=Xbboard) (bpolic01=Xbpolic01) (bpolic02=Xbpolic02) (bpolic03=Xbpolic03) (bpolic04=Xbpolic04) (bpolic05=Xbpolic05) (bpolic06=Xbpolic06) (bpolic07=Xbpolic07) (bpolic08=Xbpolic08) (bpolic09=Xbpolic09) (bconsu01=Xbconsu01) (bconsu02=Xbconsu02) (bconsu03=Xbconsu03) (bconsu04=Xbconsu04) (bconsu05=Xbconsu05) (bconsu06=Xbconsu06) (bconsu07=Xbconsu07) (bconsu08=Xbconsu08) (bconsu09=Xbconsu09) (brepor01=Xbrepor01) (brepor02=Xbrepor02) (brepor03=Xbrepor03) (brepor04=Xbrepor04) (brepor05=Xbrepor05) (brepor06=Xbrepor06) (brepor07=Xbrepor07) (brepor08=Xbrepor08) (brepor09=Xbrepor09) (bmember1=Xbmember1) (bmember2=Xbmember2) (bmember3=Xbmember3) (bmember4=Xbmember4) (badvice1=Xbadvice1) (badvice2=Xbadvice2) (badvice3=Xbadvice3) (badvice4=Xbadvice4) (badvice5=Xbadvice5) (badvice6=Xbadvice6) (badvice7=Xbadvice7) (baissue1=Xbaissue1) (baissue2=Xbaissue2) (baissue3=Xbaissue3) (bstrateg=Xbstrateg) (bmanage1=Xbmanage1) (bmanage2=Xbmanage2) (bmanage3=Xbmanage3) (bmanage4=Xbmanage4) (bmanage5=Xbmanage5) (bprepare=Xbprepare) (baward=Xbaward) (bapplied=Xbapplied) (cvacant1=Xcvacant1) (cvacant2=Xcvacant2) (cvacant3=Xcvacant3) (cvacant4=Xcvacant4) (cvacant5=Xcvacant5) (cvacant6=Xcvacant6) (cvacant7=Xcvacant7) (cvacant8=Xcvacant8) (cvacant9=Xcvacant9) (cvacdif1=Xcvacdif1) (cvacdif2=Xcvacdif2) (cvacdif3=Xcvacdif3) (cvacdif4=Xcvacdif4) (cvacdif5=Xcvacdif5) (cvacdif6=Xcvacdif6) (cvacdif7=Xcvacdif7) (cvacdif8=Xcvacdif8) (cvacdif9=Xcvacdif9) (cfillvac=Xcfillvac) (cpropor=Xcpropor) (cfactor1=Xcfactor1) (cfactor2=Xcfactor2) (cfactor3=Xcfactor3) (cfactor4=Xcfactor4) (cfactor5=Xcfactor5) (cfactor6=Xcfactor6) (cfactor7=Xcfactor7) (cfactor8=Xcfactor8) (cfactor9=Xcfactor9) (cspecia1=Xcspecia1) (cspecia2=Xcspecia2) (cspecia3=Xcspecia3) (cspecia4=Xcspecia4) (cspecia5=Xcspecia5) (catests=Xcatests) (ctestwh1=Xctestwh1) (ctestwh2=Xctestwh2) (ctestwh3=Xctestwh3) (ctestwh4=Xctestwh4) (ctestwh5=Xctestwh5) (ctestwh6=Xctestwh6) (ctestwh7=Xctestwh7) (ctestwh8=Xctestwh8) (ctestwh9=Xctestwh9) (cptests=Xcptests) (cwhodo1=Xcwhodo1) (cwhodo2=Xcwhodo2) (cwhodo3=Xcwhodo3) (cwhodo4=Xcwhodo4) (cwhodo5=Xcwhodo5) (cwhodo6=Xcwhodo6) (cwhodo7=Xcwhodo7) (cwhodo8=Xcwhodo8) (cwhodo9=Xcwhodo9) (cinduct=Xcinduct) (clongch=Xclongch) (clonghr=Xclonghr) (clongdy=Xclongdy) (cstuckin=Xcstuckin) (coffjob=Xcoffjob) (ctrain=Xctrain) (chow01=Xchow01) (chow02=Xchow02) (chow03=Xchow03) (chow04=Xchow04) (chow05=Xchow05) (chow06=Xchow06) (chow07=Xchow07) (chow08=Xchow08) (chow09=Xchow09) (chow10=Xchow10) (cjobde01=Xcjobde01) (cjobde02=Xcjobde02) (cjobde03=Xcjobde03) (cjobde04=Xcjobde04) (cjobde05=Xcjobde05) (cjobde06=Xcjobde06) (cjobde07=Xcjobde07) (cjobde08=Xcjobde08) (cjobde09=Xcjobde09) (classif=Xclassif) (cothjob=Xcothjob) (cvariety=Xcvariety) (cdiscret=Xcdiscret) (control=Xcontrol) (cteams=Xcteams) (cteamhoa=Xcteamhoa) (cteamhob=Xcteamhob) (cteamhoc=Xcteamhoc) (cteamhod=Xcteamhod) (dbrief=Xdbrief) (dbriefu1=Xdbriefu1) (dbriefu2=Xdbriefu2) (dbriefu3=Xdbriefu3) (dbriefu4=Xdbriefu4) (dbriefn=Xdbriefn) (dtwoway=Xdtwoway) (djoint=Xdjoint) (dhadany=Xdhadany) (dhowmany=Xdhowmany) (dissues=Xdissues) (dwhich01=Xdwhich01) (dwhich02=Xdwhich02) (dwhich03=Xdwhich03) (dwhich04=Xdwhich04) (dwhich05=Xdwhich05) (dwhich06=Xdwhich06) (dwhich07=Xdwhich07) (dwhich08=Xdwhich08) (dwhich09=Xdwhich09) (dwhich10=Xdwhich10) (dwhich11=Xdwhich11) (dwhich12=Xdwhich12) (disswho1=Xdisswho1) (disswho2=Xdisswho2) (disswho3=Xdisswho3) (disswho4=Xdisswho4) (disswho5=Xdisswho5) (disswho6=Xdisswho6) (disswho7=Xdisswho7) (disswho8=Xdisswho8) (dappoin1=Xdappoin1) (dappoin2=Xdappoin2) (dappoin3=Xdappoin3) (dappoin4=Xdappoin4) (dunion=Xdunion) (dmeet=Xdmeet) (dinfluen=Xdinfluen) (dhighlev=Xdhighlev) (dcouncil=Xdcouncil) (dcounuk=Xdcounuk) (dcircles=Xdcircles) (dcirc5yr=Xdcirc5yr) (dcirclif=Xdcirclif) (dpropor=Xdpropor) (dperfor1=Xdperfor1) (dperfor2=Xdperfor2) (dperfor3=Xdperfor3) (dothway1=Xdothway1) (dothway2=Xdothway2) (dothway3=Xdothway3) (dothway4=Xdothway4) (dothway5=Xdothway5) (dsurvey=Xdsurvey) (dresults=Xdresults) (dconsul1=Xdconsul1) (dconsul2=Xdconsul2) (dconsul3=Xdconsul3) (dconsul4=Xdconsul4) (dconsul5=Xdconsul5) (dconsul6=Xdconsul6) (dinvplan=Xdinvplan) (dfinance=Xdfinance) (dwholefi=Xdwholefi) (dstaffin=Xdstaffin) (eanyemp=Xeanyemp) (eemploy1=Xeemploy1) (eemploy2=Xeemploy2) (eemploy3=Xeemploy3) (eemploy4=Xeemploy4) (eemploy5=Xeemploy5) (eemploy6=Xeemploy6) (eemploy7=Xeemploy7) (eemploy8=Xeemploy8) (eemploy9=Xeemploy9) (eformerl=Xeformerl) (echange=Xechange) (ehowchd1=Xehowchd1) (ehowchd2=Xehowchd2) (ehowchd3=Xehowchd3) (ehowchi1=Xehowchi1) (ehowchi2=Xehowchi2) (erecruit=Xerecruit) (eviews=Xeviews) (echecks=Xechecks) (ekeepjob=Xekeepjob) (ehaveto=Xehaveto) (eoughto=Xeoughto) (ededuct=Xededuct) (eunionum=Xeunionum) (euniona1=Xeuniona1) (euniona2=Xeuniona2) (euniona3=Xeuniona3) (euniona4=Xeuniona4) (euniona5=Xeuniona5) (euniona6=Xeuniona6) (euniona7=Xeuniona7) (euniona8=Xeuniona8) (euniona9=Xeuniona9) (eunioa10=Xeunioa10) (erecog01=Xerecog01) (erecog02=Xerecog02) (erecog03=Xerecog03) (erecog04=Xerecog04) (erecog05=Xerecog05) (erecog06=Xerecog06) (erecog07=Xerecog07) (erecog08=Xerecog08) (erecog09=Xerecog09) (erecog10=Xerecog10) (etotrec=Xetotrec) (emostmem=Xemostmem) (eformal=Xeformal) (ejoint=Xejoint) (egroups=Xegroups) (enum5yr=Xenum5yr) (ehowcom1=Xehowcom1) (ehowcom2=Xehowcom2) (erequest=Xerequest) (esteward=Xesteward) (estewnum=Xestewnum) (estewext=Xestewext) (estewtim=Xestewtim) (eothreps=Xeothreps) (enumreps=Xenumreps) (echosen1=Xechosen1) (echosen2=Xechosen2) (esiton=Xesiton) (epaya=Xepaya) (eselecta=Xeselecta) (etraina=Xetraina) (esystema=Xesystema) (ediscipa=Xediscipa) (estaffa=Xestaffa) (equalopa=Xequalopa) (ehealtha=Xehealtha) (eperfora=Xeperfora) (epayb=Xepayb) (eselectb=Xeselectb) (etrainb=Xetrainb) (esystemb=Xesystemb) (ediscipb=Xediscipb) (estaffb=Xestaffb) (equalopb=Xequalopb) (ehealthb=Xehealthb) (eperforb=Xeperforb) (etalk5yr=Xetalk5yr) (ewhymor1=Xewhymor1) (ewhymor2=Xewhymor2) (ewhyles1=Xewhyles1) (ewhyles2=Xewhyles2) (ffacto01=Xffacto01) (ffacto02=Xffacto02) (ffacto03=Xffacto03) (ffacto04=Xffacto04) (ffacto05=Xffacto05) (ffacto06=Xffacto06) (ffacto07=Xffacto07) (ffacto08=Xffacto08) (ffacto09=Xffacto09) (ffacto10=Xffacto10) (fvarpay1=Xfvarpay1) (fvarpay2=Xfvarpay2) (fvarpay3=Xfvarpay3) (fvarpay4=Xfvarpay4) (fvarpay5=Xfvarpay5) (fprpayir=Xfprpayir) (flevel=Xflevel) (fprpoc01=Xfprpoc01) (fprpoc02=Xfprpoc02) (fprpoc03=Xfprpoc03) (fprpoc04=Xfprpoc04) (fprpoc05=Xfprpoc05) (fprpoc06=Xfprpoc06) (fprpoc07=Xfprpoc07) (fprpoc08=Xfprpoc08) (fprpoc09=Xfprpoc09) (fnonman=Xfnonman) (foccgr01=Xfoccgr01) (foccgr02=Xfoccgr02) (foccgr03=Xfoccgr03) (foccgr04=Xfoccgr04) (foccgr05=Xfoccgr05) (foccgr06=Xfoccgr06) (foccgr07=Xfoccgr07) (foccgr08=Xfoccgr08) (foccgr09=Xfoccgr09) (fsharwho=Xfsharwho) (fnonwho=Xfnonwho) (fperwho1=Xfperwho1) (fperwho2=Xfperwho2) (fperwho3=Xfperwho3) (fperwho4=Xfperwho4) (fperwho5=Xfperwho5) (fperwho6=Xfperwho6) (fperwho7=Xfperwho7) (fperwho8=Xfperwho8) (fpernon=Xfpernon) (fmeasur1=Xfmeasur1) (fmeasur2=Xfmeasur2) (fmeasur3=Xfmeasur3) (fmeasur4=Xfmeasur4) (findper1=Xfindper1) (findper2=Xfindper2) (findper3=Xfindper3) (fsocin01=Xfsocin01) (fsocin02=Xfsocin02) (fsocin03=Xfsocin03) (fsocin04=Xfsocin04) (fsocin05=Xfsocin05) (fsocin06=Xfsocin06) (fsocin07=Xfsocin07) (fsocin08=Xfsocin08) (fsocin09=Xfsocin09) (fmeaspr=Xfmeaspr) (fappwhen=Xfappwhen) (fwhoapp1=Xfwhoapp1) (fwhoapp2=Xfwhoapp2) (fwhoapp3=Xfwhoapp3) (fwhoapp4=Xfwhoapp4) (ftypeap1=Xftypeap1) (ftypeap2=Xftypeap2) (ftypeap3=Xftypeap3) (ftypeap4=Xftypeap4) (ftypeap5=Xftypeap5) (ftypeap6=Xftypeap6) (ftypeap7=Xftypeap7) (fnotpay=Xfnotpay) (freview=Xfreview) (fpaychge=Xfpaychge) (fupdown=Xfupdown) (fchg21=Xfchg21) (fpaycut=Xfpaycut) (fawardm=Xfawardm) (fawardnm=Xfawardnm) (fawardsi=Xfawardsi) (fawardsl=Xfawardsl) (flivup=Xflivup) (fperfup=Xfperfup) (factup=Xfactup) (flivdown=Xflivdown) (fperfdn=Xfperfdn) (freddn=Xfreddn) (fwhodid1=Xfwhodid1) (fwhodid2=Xfwhodid2) (fwhodid3=Xfwhodid3) (fwhodid4=Xfwhodid4) (fwhodid5=Xfwhodid5) (fwhodid6=Xfwhodid6) (fwhere=Xfwhere) (fconsult=Xfconsult) (fconsneg=Xfconsneg) (fsoc1=Xfsoc1) (fsoc2=Xfsoc2) (fsoc3=Xfsoc3) (fsoc4=Xfsoc4) (fsoc5=Xfsoc5) (fsoc6=Xfsoc6) (fsoc7=Xfsoc7) (fsoc8=Xfsoc8) (fsoc9=Xfsoc9) (fcover=Xfcover) (fbargain=Xfbargain) (fnegot=Xfnegot) (fwrite1=Xfwrite1) (fwrite2=Xfwrite2) (fwrite3=Xfwrite3) (fwrite4=Xfwrite4) (fwrite5=Xfwrite5) (fwrite6=Xfwrite6) (fcident=Xfcident) (fentitl1=Xfentitl1) (fentitl2=Xfentitl2) (fentitl3=Xfentitl3) (fentitl4=Xfentitl4) (fentitl5=Xfentitl5) (fentitl6=Xfentitl6) (fothtit1=Xfothtit1) (fothtit2=Xfothtit2) (fothtit3=Xfothtit3) (fothtit4=Xfothtit4) (fothtit5=Xfothtit5) (fothtit6=Xfothtit6) (gprocedu=Xgprocedu) (gworkis1=Xgworkis1) (gworkis2=Xgworkis2) (gworkis3=Xgworkis3) (gissues1=Xgissues1) (gissues2=Xgissues2) (gissues3=Xgissues3) (gissues4=Xgissues4) (gcovered=Xgcovered) (greferal=Xgreferal) (gprohibi=Xgprohibi) (gbody1=Xgbody1) (gbody2=Xgbody2) (gbody3=Xgbody3) (gbody4=Xgbody4) (gbody5=Xgbody5) (gbody6=Xgbody6) (gresolv1=Xgresolv1) (gresolv2=Xgresolv2) (gdispute=Xgdispute) (gused=Xgused) (gballot=Xgballot) (gnumber=Xgnumber) (gfavour=Xgfavour) (gactio01=Xgactio01) (gactio02=Xgactio02) (gactio03=Xgactio03) (gactio04=Xgactio04) (gactyr01=Xgactyr01) (gactyr02=Xgactyr02) (gactyr03=Xgactyr03) (gactyr04=Xgactyr04) (gactyr05=Xgactyr05) (gactyr06=Xgactyr06) (gactyr07=Xgactyr07) (gactyr08=Xgactyr08) (gactyr09=Xgactyr09) (gactyr10=Xgactyr10) (gact5yr=Xgact5yr) (goth5yr=Xgoth5yr) (gpicket=Xgpicket) (gdisrupt=Xgdisrupt) (gpstyr1=Xgpstyr1) (gpstyr2=Xgpstyr2) (gpstyr3=Xgpstyr3) (gpstyr4=Xgpstyr4) (gpstyr5=Xgpstyr5) (gpstyr6=Xgpstyr6) (gpstyr7=Xgpstyr7) (hprocedu=Xhprocedu) (hresolv1=Xhresolv1) (hresolv2=Xhresolv2) (hcover=Xhcover) (hraised=Xhraised) (hwhynot1=Xhwhynot1) (hwhynot2=Xhwhynot2) (hwhynot3=Xhwhynot3) (htype01=Xhtype01) (htype02=Xhtype02) (htype03=Xhtype03) (htype04=Xhtype04) (htype05=Xhtype05) (htype06=Xhtype06) (htype07=Xhtype07) (htype08=Xhtype08) (htype09=Xhtype09) (htype10=Xhtype10) (htype11=Xhtype11) (htype12=Xhtype12) (haware1=Xhaware1) (haware2=Xhaware2) (haware3=Xhaware3) (haware4=Xhaware4) (haware5=Xhaware5) (haware6=Xhaware6) (haccomp1=Xhaccomp1) (haccomp2=Xhaccomp2) (haccomp3=Xhaccomp3) (haccomp4=Xhaccomp4) (haccomp5=Xhaccomp5) (haccomp6=Xhaccomp6) (haccomp7=Xhaccomp7) (hothpro=Xhothpro) (hothcove=Xhothcove) (hothawa1=Xhothawa1) (hothawa2=Xhothawa2) (hothawa3=Xhothawa3) (hothawa4=Xhothawa4) (hothawa5=Xhothawa5) (hothawa6=Xhothawa6) (hothacc1=Xhothacc1) (hothacc2=Xhothacc2) (hothacc3=Xhothacc3) (hothacc4=Xhothacc4) (hothacc5=Xhothacc5) (hothacc6=Xhothacc6) (hothacc7=Xhothacc7) (hothacc8=Xhothacc8) (happeal=Xhappeal) (hwarning=Xhwarning) (hsuspend=Xhsuspend) (hdeduct=Xhdeduct) (hsusnum=Xhsusnum) (hcomplai=Xhcomplai) (hcom5yr=Xhcom5yr) (hcomnum=Xhcomnum) (hreason1=Xhreason1) (hreason2=Xhreason2) (hreason3=Xhreason3) (hreason4=Xhreason4) (hreason5=Xhreason5) (hreason6=Xhreason6) (hreview1=Xhreview1) (hreview2=Xhreview2) (hreview3=Xhreview3) (hreview4=Xhreview4) (hreview5=Xhreview5) (hreview6=Xhreview6) (hdeal=Xhdeal) (ipolicy=Xipolicy) (igroun01=Xigroun01) (igroun02=Xigroun02) (igroun03=Xigroun03) (igroun04=Xigroun04) (igroun05=Xigroun05) (igroun06=Xigroun06) (igroun07=Xigroun07) (igroun08=Xigroun08) (igroun09=Xigroun09) (itold1=Xitold1) (itold2=Xitold2) (itold3=Xitold3) (itold4=Xitold4) (itold5=Xitold5) (itold6=Xitold6) (imeasur=Ximeasur) (ieffect1=Xieffect1) (ieffect2=Xieffect2) (ieffect3=Xieffect3) (iwhynot1=Xiwhynot1) (iwhynot2=Xiwhynot2) (iwhynot3=Xiwhynot3) (ipracti1=Xipracti1) (ipracti2=Xipracti2) (ipracti3=Xipracti3) (ipracti4=Xipracti4) (ipracti5=Xipracti5) (ipracti6=Xipracti6) (ifmoff=Xifmoff) (imaleoff=Ximaleoff) (ipatern=Xipatern) (ifamily1=Xifamily1) (ifamily2=Xifamily2) (ifamily3=Xifamily3) (ifamily4=Xifamily4) (ifamily5=Xifamily5) (ifamily6=Xifamily6) (ifamily7=Xifamily7) (ifamprop=Xifamprop) (icosts=Xicosts) (iworthit=Xiworthit) (ifamben1=Xifamben1) (ifamben2=Xifamben2) (ifamben3=Xifamben3) (ifamben4=Xifamben4) (icommtee=Xicommtee) (ijoint=Xijoint) (irepnum1=Xirepnum1) (irepnum2=Xirepnum2) (irepnum3=Xirepnum3) (irepnum4=Xirepnum4) (iothrep=Xiothrep) (isamerep=Xisamerep) (iselect1=Xiselect1) (iselect2=Xiselect2) (iselect3=Xiselect3) (itrain=Xitrain) (iconsul1=Xiconsul1) (iconsul2=Xiconsul2) (iconsul3=Xiconsul3) (iinjury1=Xiinjury1) (iinjury2=Xiinjury2) (iinjury3=Xiinjury3) (iinjury4=Xiinjury4) (iinjury5=Xiinjury5) (iinjury6=Xiinjury6) (iinjury7=Xiinjury7) (inuminj=Xinuminj) (iillnes1=Xiillnes1) (iillnes2=Xiillnes2) (iillnes3=Xiillnes3) (iillnes4=Xiillnes4) (illnum=Xillnum) (jnonem01=Xjnonem01) (jnonem02=Xjnonem02) (jnonem03=Xjnonem03) (jnonem04=Xjnonem04) (jnonem05=Xjnonem05) (jnonem06=Xjnonem06) (jnonem07=Xjnonem07) (jnonem08=Xjnonem08) (jnonem09=Xjnonem09) (jnonem10=Xjnonem10) (jnonem11=Xjnonem11) (jyr5emp=Xjyr5emp) (jpreemp=Xjpreemp) (jwhyout1=Xjwhyout1) (jwhyout2=Xjwhyout2) (jwhyout3=Xjwhyout3) (jwhyout4=Xjwhyout4) (jwhyout5=Xjwhyout5) (jcstout=Xjcstout) (jagency=Xjagency) (jagencyy=Xjagencyy) (jsoctem1=Xjsoctem1) (jsoctem2=Xjsoctem2) (jsoctem3=Xjsoctem3) (jsoctem4=Xjsoctem4) (jsoctem5=Xjsoctem5) (jsoctem6=Xjsoctem6) (jemptem=Xjemptem) (jwhytem1=Xjwhytem1) (jwhytem2=Xjwhytem2) (jwhytem3=Xjwhytem3) (jwhytem4=Xjwhytem4) (jwhytem5=Xjwhytem5) (jwhytem6=Xjwhytem6) (jtemplyr=Xjtemplyr) (jtempmyr=Xjtempmyr) (jfiterm=Xjfiterm) (jsocfit1=Xjsocfit1) (jsocfit2=Xjsocfit2) (jsocfit3=Xjsocfit3) (jsocfit4=Xjsocfit4) (jsocfit5=Xjsocfit5) (jsocfit6=Xjsocfit6) (jsocfit7=Xjsocfit7) (jsocfit8=Xjsocfit8) (jfxtemp=Xjfxtemp) (jempfit=Xjempfit) (jwhyfit1=Xjwhyfit1) (jwhyfit2=Xjwhyfit2) (jwhyfit3=Xjwhyfit3) (jwhyfit4=Xjwhyfit4) (jwrkfree=Xjwrkfree) (jhomwrk=Xjhomwrk) (jallhom=Xjallhom) (jnemphm=Xjnemphm) (jlabcsta=Xjlabcsta) (jlabcstb=Xjlabcstb) (jlabcstc=Xjlabcstc) (jlabcstd=Xjlabcstd) (jobsec01=Xjobsec01) (jobsec02=Xjobsec02) (jobsec03=Xjobsec03) (jobsec04=Xjobsec04) (jobsec05=Xjobsec05) (jobsec06=Xjobsec06) (jobsec07=Xjobsec07) (jobsec08=Xjobsec08) (jobsec09=Xjobsec09) (jreduct=Xjreduct) (jredrea1=Xjredrea1) (jredrea2=Xjredrea2) (jredrea3=Xjredrea3) (jredrea4=Xjredrea4) (jredrea5=Xjredrea5) (jredmet1=Xjredmet1) (jredmet2=Xjredmet2) (jredmet3=Xjredmet3) (jredmet4=Xjredmet4) (jredcons=Xjredcons) (jwhocon1=Xjwhocon1) (jwhocon2=Xjwhocon2) (jwhocon3=Xjwhocon3) (jwhocon4=Xjwhocon4) (jisscon1=Xjisscon1) (jisscon2=Xjisscon2) (jisscon3=Xjisscon3) (jisscon4=Xjisscon4) (jisscon5=Xjisscon5) (jduratio=Xjduratio) (jovertim=Xjovertim) (jtimear1=Xjtimear1) (jtimear2=Xjtimear2) (jtimear3=Xjtimear3) (jtimear4=Xjtimear4) (jtimear5=Xjtimear5) (jtimear6=Xjtimear6) (kactivi=Xkactivi) (kproser=Xkproser) (kmarket=Xkmarket) (klarge=Xklarge) (kcompet=Xkcompet) (kdegree=Xkdegree) (kovrsea=Xkovrsea) (kpctshar=Xkpctshar) (kstamar=Xkstamar) (kvalsal=Xkvalsal) (kprosal=Xkprosal) (kjit=Xkjit) (kwrkplac=Xkwrkplac) (khowmon1=Xkhowmon1) (khowmon2=Xkhowmon2) (khowmon3=Xkhowmon3) (khowmon4=Xkhowmon4) (khowmon5=Xkhowmon5) (khowmon6=Xkhowmon6) (ktarge01=Xktarge01) (ktarge02=Xktarge02) (ktarge03=Xktarge03) (ktarge04=Xktarge04) (ktarge05=Xktarge05) (ktarge06=Xktarge06) (ktarge07=Xktarge07) (ktarge08=Xktarge08) (ktarge09=Xktarge09) (ktarcon=Xktarcon) (kempinf=Xkempinf) (krecper1=Xkrecper1) (krecper2=Xkrecper2) (krecper3=Xkrecper3) (krecper4=Xkrecper4) (krecper5=Xkrecper5) (krecper6=Xkrecper6) (krecper7=Xkrecper7) (krecper8=Xkrecper8) (krecper9=Xkrecper9) (kreccon=Xkreccon) (kbnchma=Xkbnchma) (kbncest1=Xkbncest1) (kbncest2=Xkbncest2) (kbncest3=Xkbncest3) (kestper1=Xkestper1) (kestper2=Xkestper2) (kestper3=Xkestper3) (kerfis=Xkerfis) (klacost=Xklacost) (klabscal=Xklabscal) (lchang01=Xlchang01) (lchang02=Xlchang02) (lchang03=Xlchang03) (lchang04=Xlchang04) (lchang05=Xlchang05) (lchang06=Xlchang06) (lchang07=Xlchang07) (lchang08=Xlchang08) (lchang09=Xlchang09) (ldegcha=Xldegcha) (limpfac1=Xlimpfac1) (limpfac2=Xlimpfac2) (limpfac3=Xlimpfac3) (limpfac4=Xlimpfac4) (limpfac5=Xlimpfac5) (lmancha1=Xlmancha1) (lmancha2=Xlmancha2) (lmancha3=Xlmancha3) (lmancha4=Xlmancha4) (lmancha5=Xlmancha5) (lmancha6=Xlmancha6) (lmancha7=Xlmancha7) (limpcha=Xlimpcha) (ltypinv1=Xltypinv1) (ltypinv2=Xltypinv2) (ltypinv3=Xltypinv3) (ltricha1=Xltricha1) (ltricha2=Xltricha2) (ltricha3=Xltricha3) (ltricha4=Xltricha4) (ltricha5=Xltricha5) (ltricha6=Xltricha6) (lunacha=Xlunacha) (lynoch01=Xlynoch01) (lynoch02=Xlynoch02) (lynoch03=Xlynoch03) (lynoch04=Xlynoch04) (lynoch05=Xlynoch05) (mrelate=Xmrelate) (mcenpro=Xmcenpro) (mnextime=Xmnextime) (mwrep=Xmwrep) (mqloc=Xmqloc) (nempsize=Xnempsize) (norgsize=Xnorgsize) /table="C:\your_path\PS9804_PQ04v3.SAV" /rename (Xsample=Ysample) (Xoutcome=Youtcome) (Xout3=Yout3) (Xemps2004=Yemps2004) (Xcode12=Yxcode12) (P98LgNo=Yp98lgno) (P98Emps=Yp98emps) (P98Recun=Yp98recun) (ZALLEMPS=Yzallemps) (ZMALFULL=Yzmalfull) (ZFEMFULL=Yzfemfull) (ZMALPRT=Yzmalprt) (ZFEMPRT=Yzfemprt) (ZTOTMEN=Yztotmen) (ZTOTWOM=Yztotwom) (ZALLPTE=Yzallpte) (ZALLFTE=Yzallfte) (zmng_tot=Yzmng_tot) (zpro_tot=Yzpro_tot) (ztec_tot=Yztec_tot) (zadm_tot=Yzadm_tot) (zskl_tot=Yzskl_tot) (zper_tot=Yzper_tot) (zsal_tot=Yzsal_tot) (zope_tot=Yzope_tot) (zrou_tot=Yzrou_tot) (SOC2000=Ysoc2000) (SOC90=Ysoc90) (ZETHNIC=Yzethnic) (ZETHNICP=Yzethnicp) (ZUNIMEM=Yzunimem) (ZUNIPC=Yzunipc) (ZANYMEM=Yzanymem) (ASINGLE=Yasingle) (AUKTOT=Yauktot) (ACOMP01=Yacomp01) (ACOMP02=Yacomp02) (ACOMP03=Yacomp03) (ACOMP04=Yacomp04) (ACOMP05=Yacomp05) (ACOMP06=Yacomp06) (ACOMP07=Yacomp07) (ACOMP08=Yacomp08) (ACOMP09=Yacomp09) (ACOMP10=Yacomp10) (ACOMP11=Yacomp11) (ACOMP12=Yacomp12) (ACONTROL=Yacontrol) (ACONHEAD=Yaconhead) (AHowCh01=Yahowch01) (AHowCh02=Yahowch02) (AHowCh03=Yahowch03) (AHowCh04=Yahowch04) (AHowCh05=Yahowch05) (AHowCh06=Yahowch06) (AHowCh07=Yahowch07) (AHowCh08=Yahowch08) (AHowCh09=Yahowch09) (AHowCh10=Yahowch10) (AHowCh11=Yahowch11) (AHowCh12=Yahowch12) (AHowCh13=Yahowch13) (APHRAS01=Yaphras01) (APHRAS02=Yaphras02) (APHRAS03=Yaphras03) (APHRAS04=Yaphras04) (APHRAS06=Yaphras06) (APHRAS07=Yaphras07) (APHRAS09=Yaphras09) (APHRAS10=Yaphras10) (BSEX=Ybsex) (XBTITLE=Yxbtitle) (Back1=Yback1) (BUMANAGE=Ybumanage) (BPROPORT=Ybproport) (BBOARD=Ybboard) (BSTRATEG=Ybstrateg) (BMANAGE=Ybmanage) (CFILLVAC=Ycfillvac) (CFACTOR1=Ycfactor1) (CFACTOR2=Ycfactor2) (CFACTOR3=Ycfactor3) (CFACTOR4=Ycfactor4) (CFACTOR5=Ycfactor5) (CFACTOR6=Ycfactor6) (CFACTOR7=Ycfactor7) (CFACTOR8=Ycfactor8) (CFACTOR9=Ycfactor9) (XCFACT1=Yxcfact1) (XCFACT2=Yxcfact2) (XCFACT3=Yxcfact3) (CSPECIA1=Ycspecia1) (CSPECIA2=Ycspecia2) (CSPECIA3=Ycspecia3) (CSPECIA4=Ycspecia4) (CSPECIA5=Ycspecia5) (CSPECIA6=Ycspecia6) (CPTESTS=Ycptests) (COFFJOB=Ycoffjob) (COTHJOB=Ycothjob) (CTEAMS=Ycteams) (CTEAMHOA=Ycteamhoa) (CTEAMHOC=Ycteamhoc) (CTEAMHOD=Ycteamhod) (DBRIEF=Ydbrief) (DBRIEFU1=Ydbriefu1) (DBRIEFU2=Ydbriefu2) (DBRIEFU3=Ydbriefu3) (DBRIEFU4=Ydbriefu4) (XDBRIEF1=Yxdbrief1) (XDBRIEF2=Yxdbrief2) (XDBRIEF3=Yxdbrief3) (DTWOWAY=Ydtwoway) (DJOINT=Ydjoint) (DISSUES=Ydissues) (DAPPOIN1=Ydappoin1) (DAPPOIN2=Ydappoin2) (DAPPOIN3=Ydappoin3) (DAPPOIN4=Ydappoin4) (DAPPOIN5=Ydappoin5) (DMEET=Ydmeet) (DHIGHLEV=Ydhighlev) (DCIRCLES=Ydcircles) (DPROPOR=Ydpropor) (DCONSUL1=Ydconsul1) (DCONSUL2=Ydconsul2) (DCONSUL3=Ydconsul3) (DCONSUL4=Ydconsul4) (DCONSUL5=Ydconsul5) (DCONSUL6=Ydconsul6) (XDCONSU1=Yxdconsu1) (XDCONSU2=Yxdconsu2) (XDCONSU3=Yxdconsu3) (DINVPLAN=Ydinvplan) (DFINANCE=Ydfinance) (DWHOLEFI=Ydwholefi) (DSTAFFIN=Ydstaffin) (EANYEMP=Yeanyemp) (EEMPLOY1=Yeemploy1) (EEMPLOY2=Yeemploy2) (EEMPLOY3=Yeemploy3) (EEMPLOY4=Yeemploy4) (EEMPLOY5=Yeemploy5) (EEMPLOY6=Yeemploy6) (EEMPLOY7=Yeemploy7) (EEMPLOY8=Yeemploy8) (EEMPLOY9=Yeemploy9) (EVIEWS=Yeviews) (XEVIEWS=Yxeviews) (EUNIONUM=Yeunionum) (EUNIONCK=Yeunionck) (ENUMREC=Yenumrec) (ENEW=Yenew) (ENEWNUM=Yenewnum) (EWIDER=Yewider) (EWIDNUM=Yewidnum) (EUDREC=Yeudrec) (EREQUEST=Yerequest) (EJOINT=Yejoint) (EGROUPS=Yegroups) (ESTEWARD=Yesteward) (ESTEWNUM=Yestewnum) (ESTEWEXT=Yestewext) (ESTEWTIM=Yestewtim) (EOTHREPS=Yeothreps) (ENUMREPS=Yenumreps) (ESITON=Yesiton) (FVARPAY1=Yfvarpay1) (FVARPAY2=Yfvarpay2) (FVARPAY3=Yfvarpay3) (FVARPAY4=Yfvarpay4) (FVARPAY5=Yfvarpay5) (FVARPAY6=Yfvarpay6) (FPROFIT=Yfprofit) (FSHAR=Yfshar) (FPERFP=Yfperfp) (FMEASUR1=Yfmeasur1) (FMEASUR2=Yfmeasur2) (FMEASUR3=Yfmeasur3) (FMEASUR4=Yfmeasur4) (FMEASUR5=Yfmeasur5) (XFMEASU1=Yxfmeasu1) (XFMEASU2=Yxfmeasu2) (XFMEASU3=Yxfmeasu3) (FINDPER1=Yfindper1) (FINDPER2=Yfindper2) (FINDPER3=Yfindper3) (FINDPER4=Yfindper4) (FINDPER5=Yfindper5) (XFINDPE1=Yxfindpe1) (XFINDPE2=Yxfindpe2) (XFINDPE3=Yxfindpe3) (FNMPERF=Yfnmperf) (FNOTPAY=Yfnotpay) (FSOCINTR=Yfsocintr) (FSOC1=Yfsoc1) (FSOC2=Yfsoc2) (FSOC3=Yfsoc3) (FSOC4=Yfsoc4) (FSOC5=Yfsoc5) (FSOC6=Yfsoc6) (FSOC7=Yfsoc7) (FSOC8=Yfsoc8) (FSOC9=Yfsoc9) (IPOLICY=Yipolicy) (IGROUN01=Yigroun01) (IGROUN02=Yigroun02) (IGROUN03=Yigroun03) (IGROUN04=Yigroun04) (IGROUN05=Yigroun05) (IGROUN06=Yigroun06) (IGROUN07=Yigroun07) (IGROUN08=Yigroun08) (IGROUN09=Yigroun09) (IGROUN10=Yigroun10) (IPRACTI1=Yipracti1) (IPRACTI2=Yipracti2) (IPRACTI3=Yipracti3) (IPRACTI4=Yipracti4) (IPRACTI5=Yipracti5) (IPRACTI6=Yipracti6) (IFMOFF=Yifmoff) (XIFMOFF=Yxifmoff) (IPATERN=Yipatern) (IFAMILY1=Yifamily1) (IFAMILY2=Yifamily2) (IFAMILY3=Yifamily3) (IFAMILY4=Yifamily4) (IFAMILY5=Yifamily5) (IFAMILY6=Yifamily6) (IFAMILY7=Yifamily7) (IFAMILY8=Yifamily8) (JNONEM01=Yjnonem01) (JNONEM02=Yjnonem02) (JNONEM03=Yjnonem03) (JNONEM04=Yjnonem04) (JNONEM05=Yjnonem05) (JNONEM06=Yjnonem06) (JNONEM07=Yjnonem07) (JNONEM08=Yjnonem08) (JNONEM09=Yjnonem09) (JNONEM10=Yjnonem10) (JNONEM11=Yjnonem11) (JAGENCY=Yjagency) (JNWTEMP=Yjnwtemp) (JWRKFREE=Yjwrkfree) (JHOMWRK=Yjhomwrk) (JOBSEC=Yjobsec) (JTIMEAR1=Yjtimear1) (JTIMEAR2=Yjtimear2) (JTIMEAR3=Yjtimear3) (JTIMEAR4=Yjtimear4) (JTIMEAR5=Yjtimear5) (JTIMEAR6=Yjtimear6) (JTIMEAR7=Yjtimear7) (JTIMEAR8=Yjtimear8) (KINTEXT=Ykintext) (KMARKET=Ykmarket) (KCOMPET=Ykcompet) (KTARGE01=Yktarge01) (KTARGE02=Yktarge02) (KTARGE03=Yktarge03) (KTARGE04=Yktarge04) (KTARGE05=Yktarge05) (KTARGE06=Yktarge06) (KTARGE07=Yktarge07) (KTARGE08=Yktarge08) (KTARGE09=Yktarge09) (KTARGE10=Yktarge10) (KPINT=Ykpint) (KERFIS=Ykerfis) (XKERFIS=Yxkerfis) (KPint2=Ykpint2) (KOPTB=Ykoptb) (KIMP=Ykimp) (KTable=Yktable) (Kdeti=Ykdeti) (MRELATE=Ymrelate) (MRel=Ymrel) (MEND=Ymend) (MLInkdat=Ymlinkdat) (MNEXTIME=Ymnextime) (DATE1=Ydate1) (DATE2=Ydate2) (IntLoc=Yintloc) (Xcode1=Yxcode1) (Xcode2=Yxcode2) (Xcode3=Yxcode3) (Xcode4=Yxcode4) (Xcode5=Yxcode5) (Xcode6=Yxcode6) (Xcode7=Yxcode7) (Xcode8=Yxcode8) (Xcode9=Yxcode9) (Xcode10=Yxcode10) (Xcode11=Yxcode11) (asic92=Yasic92) (asic80=Yasic80) (asic2003=Yasic2003) (gor=Ygor) (ssr=Yssr) /drop=est_wt grosswt emp_wt Ydtwoway /by serno . exec . * Step 2: Enforce consistency in missing values . recode xzallemps to xnorgsize (sysmis=-1) (missing=-9) . exec. missing values xzallemps to xnorgsize (-9 thru -1) . recode yzallemps to yzrou_tot ysoc90 to yintloc (-8=-9) . add value labels xzallemps to xnorgsize yzallemps to yzrou_tot ysoc90 to yintloc -1 "Not asked" -8 "" -9 "DK/NA" . exec. * Step 3: Enforce consistency in variable names and derivations . * Note that the dataset no longer matches the questionnaire in these instances . rename variables (yzunimem=Yztu_mem) (yzunipc=Yztu_pc) (yzadm_tot=Yzcle_tot) (yzskl_tot=Yzcrt_tot) (yzper_tot=Yzptc_tot) (ysicode=Yasic) (yxbtitle=Ybtitle2) (yenumrec=Yetotrec) . compute yzscode=trunc(ysoc90/10) . recode Ybtitle2 (1=2) (2=1) (3=4) (4=3) (5,6=copy) (95=7) . value labels Ybtitle2 1 "Human Resources Manager / Officer" 2 "Personnel Manager / Officer" 3 "Employee ~ Industrial ~ Staff ~ Relations Manager / Officer" 4 "Proprietor / Owner / Managing Director / Partner" 5 "Financial Manager / Company Secretary" 6 "General Manager" 7 "Other specific answer, not codeable to 1-6" -9 "DK/NA" -1 "Not asked" . recode Ydjoint (2=1) (3=2) . add value labels Ydjoint 1 "Yes" 2 "No" 3 "" . numeric Xjtimear7 (f2.0) . variable labels Xjtimear7 "Do you have any of the following working time arrangements for any non-managerial employees?". missing values xjtimear7 (-9 thru -1) . value labels Xjtimear7 -9 "DK/NA" -1 "Not asked" 1 "Annualised hours" 2 "Regularly working in excess of 48 hours per week" 3 "Flexitime" 4 "Shift working" 5 "Sunday-only working" 6 "Zero-hour contracts" 7 "9 day fortnight/ 4.5 day week" 8 "None of these" . * Step 4: Save the data file in wide form . save outfile="C:\your_path\PS9804_WIDEv3.SAV" . exec . ************************************************** . * Construct a panel dataset in long form . * Notes: * 1. Syntax begins with panel dataset in wide form (see above) . * 2. Workplaces that were not re-interviewed in 2004 are dropped . * 3. A new variable - YEAR - identifies the year to which each row of data relates . * 4. Variables that are not wholly consistent between 1998 and 2004 are dropped . * The following vars from 2004 are not included in the long dataset. Users will be able to 'recover' * many of these by manipulating them to ensure consistency with 1998 (e.g. recoding Xauktot * and Yauktot so that they have a consistent code list) . * * Ysoc2000, Yauktot, Yacomp01-12, Yahowch01-13, Ybmanage, Ycfactor1-Yxcfact3, Ycspecia6 (empty), * Ydbriefu1-Yxdbrief3, Ydappoin1-Ydappoin5, Ydconsul1-Yxdconsu3, Yeviews-Yxeviews, Yenew, Yenewnum, * Yewider, Yewidnum, Yeudrec, Yerequest, Yfvarpay6 (empty), Yfprofit, Yfshar, Yfperfp, Yfmeasur1-Yxfmeasu3, * Yfindper1-Yxfindpe4, Yfnmperf, Yfnotpay, Yigroun10 (empty), Yifmoff, Yipatern, Yifamily8 (empty), * Yjnwtemp, Yjobsec, Yjtimear8 (empty), Ykmarket, Ykcompet, Yktarge10 (empty), Ykerfis, Ykoptb, * Ykimp, Yktable, Ykdeti, Ymrel, Ymlinkdat, Ymnextime * * 5. Note that the region and industry identifiers for 2004 added in Version 2 of the panel data file (Yasic92, Yasic80, * Yasic2003, Ygor, Yssr) are also not included in the long dataset. ************************************************** . * Step 1: Read in the wide dataset, drop workplaces that were not re-interviewed and restructure the data file . * Inconsistent variables are dropped and a new index variable (YEAR) is created . get file="C:\your_path\PS9804_WIDEv3.SAV" . select if missing(pqwtnr)=0 . varstocases /MAKE zallemps FROM xzallemps yzallemps /MAKE zmalfull FROM xzmalfull yzmalfull /MAKE zfemfull FROM xzfemfull yzfemfull /MAKE zmalprt FROM xzmalprt yzmalprt /MAKE zfemprt FROM xzfemprt yzfemprt /MAKE ztotmen FROM xztotmen yztotmen /MAKE ztotwom FROM xztotwom yztotwom /MAKE zallpte FROM xzallpte yzallpte /MAKE zallfte FROM xzallfte yzallfte /MAKE zmng_tot FROM xzmng_tot yzmng_tot /MAKE zpro_tot FROM xzpro_tot yzpro_tot /MAKE ztec_tot FROM xztec_tot yztec_tot /MAKE zcle_tot FROM xzcle_tot yzcle_tot /MAKE zcrt_tot FROM xzcrt_tot yzcrt_tot /MAKE zptc_tot FROM xzptc_tot yzptc_tot /MAKE zsal_tot FROM xzsal_tot yzsal_tot /MAKE zope_tot FROM xzope_tot yzope_tot /MAKE zrou_tot FROM xzrou_tot yzrou_tot /MAKE zethnic FROM xzethnic yzethnic /MAKE zethnicp FROM xzethnicp yzethnicp /MAKE ztu_mem FROM xztu_mem yztu_mem /MAKE ztu_pc FROM xztu_pc yztu_pc /MAKE zanymem FROM xzanymem yzanymem /MAKE zscode FROM xzscode yzscode /MAKE asic FROM xasic yasic /MAKE asingle FROM xasingle yasingle /MAKE acontrol FROM xacontrol yacontrol /MAKE aconhead FROM xaconhead yaconhead /MAKE aphras01 FROM xaphras01 yaphras01 /MAKE aphras02 FROM xaphras02 yaphras02 /MAKE aphras03 FROM xaphras03 yaphras03 /MAKE aphras04 FROM xaphras04 yaphras04 /MAKE aphras06 FROM xaphras06 yaphras06 /MAKE aphras07 FROM xaphras07 yaphras07 /MAKE aphras09 FROM xaphras09 yaphras09 /MAKE aphras10 FROM xaphras10 yaphras10 /MAKE bsex FROM xbsex ybsex /MAKE btitle2 FROM xbtitle2 ybtitle2 /MAKE bumanage FROM xbumanage ybumanage /MAKE bproport FROM xbproport ybproport /MAKE bboard FROM xbboard ybboard /MAKE bstrateg FROM xbstrateg ybstrateg /MAKE cfillvac FROM xcfillvac ycfillvac /MAKE cspecia1 FROM xcspecia1 ycspecia1 /MAKE cspecia2 FROM xcspecia2 ycspecia2 /MAKE cspecia3 FROM xcspecia3 ycspecia3 /MAKE cspecia4 FROM xcspecia4 ycspecia4 /MAKE cspecia5 FROM xcspecia5 ycspecia5 /MAKE cptests FROM xcptests ycptests /MAKE coffjob FROM xcoffjob ycoffjob /MAKE cothjob FROM xcothjob ycothjob /MAKE cteams FROM xcteams ycteams /MAKE cteamhoa FROM xcteamhoa ycteamhoa /MAKE cteamhoc FROM xcteamhoc ycteamhoc /MAKE cteamhod FROM xcteamhod ycteamhod /MAKE dbrief FROM xdbrief ydbrief /MAKE djoint FROM xdjoint ydjoint /MAKE dissues FROM xdissues ydissues /MAKE dmeet FROM xdmeet ydmeet /MAKE dhighlev FROM xdhighlev ydhighlev /MAKE dcircles FROM xdcircles ydcircles /MAKE dpropor FROM xdpropor ydpropor /MAKE dinvplan FROM xdinvplan ydinvplan /MAKE dfinance FROM xdfinance ydfinance /MAKE dwholefi FROM xdwholefi ydwholefi /MAKE dstaffin FROM xdstaffin ydstaffin /MAKE eanyemp FROM xeanyemp yeanyemp /MAKE eemploy1 FROM xeemploy1 yeemploy1 /MAKE eemploy2 FROM xeemploy2 yeemploy2 /MAKE eemploy3 FROM xeemploy3 yeemploy3 /MAKE eemploy4 FROM xeemploy4 yeemploy4 /MAKE eemploy5 FROM xeemploy5 yeemploy5 /MAKE eemploy6 FROM xeemploy6 yeemploy6 /MAKE eemploy7 FROM xeemploy7 yeemploy7 /MAKE eemploy8 FROM xeemploy8 yeemploy8 /MAKE eemploy9 FROM xeemploy9 yeemploy9 /MAKE eunionum FROM xeunionum yeunionum /MAKE etotrec FROM xetotrec yetotrec /MAKE ejoint FROM xejoint yejoint /MAKE egroups FROM xegroups yegroups /MAKE esteward FROM xesteward yesteward /MAKE estewnum FROM xestewnum yestewnum /MAKE estewext FROM xestewext yestewext /MAKE estewtim FROM xestewtim yestewtim /MAKE eothreps FROM xeothreps yeothreps /MAKE enumreps FROM xenumreps yenumreps /MAKE esiton FROM xesiton yesiton /MAKE fvarpay1 FROM xfvarpay1 yfvarpay1 /MAKE fvarpay2 FROM xfvarpay2 yfvarpay2 /MAKE fvarpay3 FROM xfvarpay3 yfvarpay3 /MAKE fvarpay4 FROM xfvarpay4 yfvarpay4 /MAKE fvarpay5 FROM xfvarpay5 yfvarpay5 /MAKE fsoc1 FROM xfsoc1 yfsoc1 /MAKE fsoc2 FROM xfsoc2 yfsoc2 /MAKE fsoc3 FROM xfsoc3 yfsoc3 /MAKE fsoc4 FROM xfsoc4 yfsoc4 /MAKE fsoc5 FROM xfsoc5 yfsoc5 /MAKE fsoc6 FROM xfsoc6 yfsoc6 /MAKE fsoc7 FROM xfsoc7 yfsoc7 /MAKE fsoc8 FROM xfsoc8 yfsoc8 /MAKE fsoc9 FROM xfsoc9 yfsoc9 /MAKE ipolicy FROM xipolicy yipolicy /MAKE igroun01 FROM xigroun01 yigroun01 /MAKE igroun02 FROM xigroun02 yigroun02 /MAKE igroun03 FROM xigroun03 yigroun03 /MAKE igroun04 FROM xigroun04 yigroun04 /MAKE igroun05 FROM xigroun05 yigroun05 /MAKE igroun06 FROM xigroun06 yigroun06 /MAKE igroun07 FROM xigroun07 yigroun07 /MAKE igroun08 FROM xigroun08 yigroun08 /MAKE igroun09 FROM xigroun09 yigroun09 /MAKE ipracti1 FROM xipracti1 yipracti1 /MAKE ipracti2 FROM xipracti2 yipracti2 /MAKE ipracti3 FROM xipracti3 yipracti3 /MAKE ipracti4 FROM xipracti4 yipracti4 /MAKE ipracti5 FROM xipracti5 yipracti5 /MAKE ipracti6 FROM xipracti6 yipracti6 /MAKE ifamily1 FROM xifamily1 yifamily1 /MAKE ifamily2 FROM xifamily2 yifamily2 /MAKE ifamily3 FROM xifamily3 yifamily3 /MAKE ifamily4 FROM xifamily4 yifamily4 /MAKE ifamily5 FROM xifamily5 yifamily5 /MAKE ifamily6 FROM xifamily6 yifamily6 /MAKE ifamily7 FROM xifamily7 yifamily7 /MAKE jnonem01 FROM xjnonem01 yjnonem01 /MAKE jnonem02 FROM xjnonem02 yjnonem02 /MAKE jnonem03 FROM xjnonem03 yjnonem03 /MAKE jnonem04 FROM xjnonem04 yjnonem04 /MAKE jnonem05 FROM xjnonem05 yjnonem05 /MAKE jnonem06 FROM xjnonem06 yjnonem06 /MAKE jnonem07 FROM xjnonem07 yjnonem07 /MAKE jnonem08 FROM xjnonem08 yjnonem08 /MAKE jnonem09 FROM xjnonem09 yjnonem09 /MAKE jnonem10 FROM xjnonem10 yjnonem10 /MAKE jnonem11 FROM xjnonem11 yjnonem11 /MAKE jagency FROM xjagency yjagency /MAKE jwrkfree FROM xjwrkfree yjwrkfree /MAKE jhomwrk FROM xjhomwrk yjhomwrk /MAKE jtimear1 FROM xjtimear1 yjtimear1 /MAKE jtimear2 FROM xjtimear2 yjtimear2 /MAKE jtimear3 FROM xjtimear3 yjtimear3 /MAKE jtimear4 FROM xjtimear4 yjtimear4 /MAKE jtimear5 FROM xjtimear5 yjtimear5 /MAKE jtimear6 FROM xjtimear6 yjtimear6 /MAKE jtimear7 FROM xjtimear7 yjtimear7 /MAKE ktarge01 FROM xktarge01 yktarge01 /MAKE ktarge02 FROM xktarge02 yktarge02 /MAKE ktarge03 FROM xktarge03 yktarge03 /MAKE ktarge04 FROM xktarge04 yktarge04 /MAKE ktarge05 FROM xktarge05 yktarge05 /MAKE ktarge06 FROM xktarge06 yktarge06 /MAKE ktarge07 FROM xktarge07 yktarge07 /MAKE ktarge08 FROM xktarge08 yktarge08 /MAKE ktarge09 FROM xktarge09 yktarge09 /MAKE mrelate FROM xmrelate ymrelate /index=year /keep serno . recode year (1=1998) (2=2004) . * Step 2: The weight variable for re-interviewed cases is matched onto the resulting data file . match files file=* /table="C:\your_path\PS9804_PQ04v3.SAV" /keep=serno to mrelate pqwtnr /by serno . exec . * Step 3: Save the data file in long form . save outfile="C:\your_path\PS9804_LONGv3.SAV" . exec .