How to perform the Method of Correlated Vectors : NLSY97 SPSS Syntax

The three last rows of the syntax (after WEIGHT OFF.) depend on how you have coded the variables of race gaps with g and non g factor scores partialed out, the correlations being displayed in the series of partial correlation at the end of the syntax below. But those three last rows will not work until the variables and these numbers have been created and entered in SPSS data editor. Still, these rows will run automatically with my SPSS file, available at request.

The ASVAB subtest variables may be a little bit complicated, since it they were splitted in half (negative and positive). See Appendix 10: CAT-ASVAB Scores.

R05363.00 KEY!SEX KEY!SEX, RS GENDER (SYMBOL) 1997
R05364.02 KEY!BDATE_Y KEY!BDATE, RS BIRTHDATE MONTH/YEAR (SYMBOL) 1997
R05386.00 KEY!ETHNICITY KEY!ETHNICITY, IS R HISPANIC (SYMBOL) 1997
R05387.00 KEY!RACE KEY!RACE, RACE OF R (SYMBOL) 1997
R14826.00 KEY!RACE_ETHNICITY KEY!RACE_ETHNICITY, COMBINED RACE AND ETHNICITY (SYMBOL) 1997
R11930.00 SIDCODE HOUSEHOLD IDENTIFICATION CODE 1997
R13091.00 YOUTH_SIBRELY01.01 YOUTH, RELATIONSHIP OF 1ST OTHER RESPONDENT IN R 01 HOUSEHOLD (ROS ITEM) 1997
R13092.00 YOUTH_SIBRELY02.01 YOUTH, RELATIONSHIP OF 2ND OTHER RESPONDENT IN R 01 HOUSEHOLD (ROS ITEM) 1997
R12362.01 SAMPLING_PANEL_WEIGHT ROUND 1 SAMPLING WEIGHT PANEL METHOD 1997
R97052.00 ASVAB_GS_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR GS CAT-ASVAB SUBTEST 1999
R97053.00 ASVAB_AR_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR AR CAT-ASVAB SUBTEST 1999
R97054.00 ASVAB_WK_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR WK CAT-ASVAB SUBTEST 1999
R97055.00 ASVAB_PC_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR PC CAT-ASVAB SUBTEST 1999
R97056.00 ASVAB_NO_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR NO CAT-ASVAB SUBTEST 1999
R97057.00 ASVAB_CS_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR CS CAT-ASVAB SUBTEST 1999
R97058.00 ASVAB_AI_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR AI CAT-ASVAB SUBTEST 1999
R97059.00 ASVAB_SI_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR SI CAT-ASVAB SUBTEST 1999
R97060.00 ASVAB_MK_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR MK CAT-ASVAB SUBTEST 1999
R97061.00 ASVAB_MC_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR MC CAT-ASVAB SUBTEST 1999
R97062.00 ASVAB_EI_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR EI CAT-ASVAB SUBTEST 1999
R97063.00 ASVAB_AO_ABILITY_EST_POS FINAL POSITIVE ABILITY ESTIMATE FOR AO CAT-ASVAB SUBTEST 1999
R97064.00 ASVAB_GS_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR GS CAT-ASVAB SUBTEST 1999
R97065.00 ASVAB_AR_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR AR CAT-ASVAB SUBTEST 1999
R97066.00 ASVAB_WK_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR WK CAT-ASVAB SUBTEST 1999
R97067.00 ASVAB_PC_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR PC CAT-ASVAB SUBTEST 1999
R97068.00 ASVAB_NO_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR NO CAT-ASVAB SUBTEST 1999
R97069.00 ASVAB_CS_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR CS CAT-ASVAB SUBTEST 1999
R97070.00 ASVAB_AI_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR AI CAT-ASVAB SUBTEST 1999
R97071.00 ASVAB_SI_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR SI CAT-ASVAB SUBTEST 1999
R97072.00 ASVAB_MK_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR MK CAT-ASVAB SUBTEST 1999
R97073.00 ASVAB_MC_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR MC CAT-ASVAB SUBTEST 1999
R97074.00 ASVAB_EI_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR EI CAT-ASVAB SUBTEST 1999
R97075.00 ASVAB_AO_ABILITY_EST_NEG FINAL NEGATIVE ABILITY ESTIMATE FOR AO CAT-ASVAB SUBTEST 1999
R98296.00 ASVAB_MATH_VERBAL_SCORE_PCT ASVAB MATH_VERBAL SCORE PERCENT 1999

IF R0538700=2 BW=1.
IF R0538700=1 and R1482600=4 BW=2.

IF R0538700=2 BH=1.
IF R1482600=2 BH=2.

IF R1482600=2 HW=1.
IF R0538700=1 and R1482600=4 HW=2.

IF R0538700=2 BHW=1.
IF R1482600=2 BHW=2.
IF R0538700=1 and R1482600=4 BHW=3.

RECODE R1482600 (1=1) (4=2) (ELSE=SYSMIS) INTO BW_RACE.
VARIABLE LABELS BW_RACE ‘BWRACE_var’.
EXECUTE.

RECODE R9705200 (0 thru highest=Copy) INTO GSPOSrecode.
RECODE R9705300 (0 thru highest=Copy) INTO ARPOSrecode.
RECODE R9705400 (0 thru highest=Copy) INTO WKPOSrecode.
RECODE R9705500 (0 thru highest=Copy) INTO PCPOSrecode.
RECODE R9705600 (0 thru highest=Copy) INTO NOPOSrecode.
RECODE R9705700 (0 thru highest=Copy) INTO CSPOSrecode.
RECODE R9705800 (0 thru highest=Copy) INTO AIPOSrecode.
RECODE R9705900 (0 thru highest=Copy) INTO SIPOSrecode.
RECODE R9706000 (0 thru highest=Copy) INTO MKPOSrecode.
RECODE R9706100 (0 thru highest=Copy) INTO MCPOSrecode.
RECODE R9706200 (0 thru highest=Copy) INTO EIPOSrecode.
RECODE R9706300 (0 thru highest=Copy) INTO AOPOSrecode.
EXECUTE.

RECODE R9706400 (0 thru highest=Copy) INTO GSNEGrecode.
RECODE R9706500 (0 thru highest=Copy) INTO ARNEGrecode.
RECODE R9706600 (0 thru highest=Copy) INTO WKNEGrecode.
RECODE R9706700 (0 thru highest=Copy) INTO PCNEGrecode.
RECODE R9706800 (0 thru highest=Copy) INTO NONEGrecode.
RECODE R9706900 (0 thru highest=Copy) INTO CSNEGrecode.
RECODE R9707000 (0 thru highest=Copy) INTO AINEGrecode.
RECODE R9707100 (0 thru highest=Copy) INTO SINEGrecode.
RECODE R9707200 (0 thru highest=Copy) INTO MKNEGrecode.
RECODE R9707300 (0 thru highest=Copy) INTO MCNEGrecode.
RECODE R9707400 (0 thru highest=Copy) INTO EINEGrecode.
RECODE R9707500 (0 thru highest=Copy) INTO AONEGrecode.
EXECUTE.

COMPUTE RECODEGSNEG=GSNEGrecode*-1.
COMPUTE RECODEARNEG=ARNEGrecode*-1.
COMPUTE RECODEWKNEG=WKNEGrecode*-1.
COMPUTE RECODEPCNEG=PCNEGrecode*-1.
COMPUTE RECODENONEG=NONEGrecode*-1.
COMPUTE RECODECSNEG=CSNEGrecode*-1.
COMPUTE RECODEAINEG=AINEGrecode*-1.
COMPUTE RECODESINEG=SINEGrecode*-1.
COMPUTE RECODEMKNEG=MKNEGrecode*-1.
COMPUTE RECODEMCNEG=MCNEGrecode*-1.
COMPUTE RECODEEINEG=EINEGrecode*-1.
COMPUTE RECODEAONEG=AONEGrecode*-1.
EXECUTE.

COMPUTE CombGS = SUM(GSPOSrecode, RECODEGSNEG).
COMPUTE CombAR = SUM(ARPOSrecode, RECODEARNEG).
COMPUTE CombWK = SUM(WKPOSrecode, RECODEWKNEG).
COMPUTE CombPC = SUM(PCPOSrecode, RECODEPCNEG).
COMPUTE CombNO = SUM(NOPOSrecode, RECODENONEG).
COMPUTE CombCS = SUM(CSPOSrecode, RECODECSNEG).
COMPUTE CombAI = SUM(AIPOSrecode, RECODEAINEG).
COMPUTE CombSI = SUM(SIPOSrecode, RECODESINEG).
COMPUTE CombMK = SUM(MKPOSrecode, RECODEMKNEG).
COMPUTE CombMC = SUM(MCPOSrecode, RECODEMCNEG).
COMPUTE CombEI = SUM(EIPOSrecode, RECODEEINEG).
COMPUTE CombAO = SUM(AOPOSrecode, RECODEAONEG).
EXECUTE.

WEIGHT BY R1236201.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombGS
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombAR
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombWK
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombPC
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombNO
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombCS
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombAI
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombSI
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombMK
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombMC
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombEI
/METHOD=ENTER R0536402
/SAVE RESID.

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT CombAO
/METHOD=ENTER R0536402
/SAVE RESID.

USE ALL.
COMPUTE filter_$=(BHW=1).
VARIABLE LABELS filter_$ ‘BHW=1 (FILTER)’.
VALUE LABELS filter_$ 0 ‘Not Selected’ 1 ‘Selected’.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

FACTOR
/VARIABLES RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 RES_7 RES_8 RES_9 RES_10 RES_11 RES_12
/MISSING LISTWISE
/ANALYSIS RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 RES_7 RES_8 RES_9 RES_10 RES_11 RES_12
/PRINT UNIVARIATE INITIAL CORRELATION SIG DET KMO EXTRACTION
/PLOT EIGEN
/CRITERIA MINEIGEN(1) ITERATE(25)
/EXTRACTION PAF
/ROTATION NOROTATE
/SAVE REG(ALL)
/METHOD=CORRELATION.

USE ALL.
COMPUTE filter_$=(BHW=2).
VARIABLE LABELS filter_$ ‘BHW=2 (FILTER)’.
VALUE LABELS filter_$ 0 ‘Not Selected’ 1 ‘Selected’.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

FACTOR
/VARIABLES RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 RES_7 RES_8 RES_9 RES_10 RES_11 RES_12
/MISSING LISTWISE
/ANALYSIS RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 RES_7 RES_8 RES_9 RES_10 RES_11 RES_12
/PRINT UNIVARIATE INITIAL CORRELATION SIG DET KMO EXTRACTION
/PLOT EIGEN
/CRITERIA MINEIGEN(1) ITERATE(25)
/EXTRACTION PAF
/ROTATION NOROTATE
/SAVE REG(ALL)
/METHOD=CORRELATION.

USE ALL.
COMPUTE filter_$=(BHW=3).
VARIABLE LABELS filter_$ ‘BHW=3 (FILTER)’.
VALUE LABELS filter_$ 0 ‘Not Selected’ 1 ‘Selected’.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

FACTOR
/VARIABLES RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 RES_7 RES_8 RES_9 RES_10 RES_11 RES_12
/MISSING LISTWISE
/ANALYSIS RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 RES_7 RES_8 RES_9 RES_10 RES_11 RES_12
/PRINT UNIVARIATE INITIAL CORRELATION SIG DET KMO EXTRACTION
/PLOT EIGEN
/CRITERIA MINEIGEN(1) ITERATE(25)
/EXTRACTION PAF
/ROTATION NOROTATE
/SAVE REG(ALL)
/METHOD=CORRELATION.

FILTER OFF.
USE ALL.
EXECUTE.

FACTOR
/VARIABLES RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 RES_7 RES_8 RES_9 RES_10 RES_11 RES_12
/MISSING LISTWISE
/ANALYSIS RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 RES_7 RES_8 RES_9 RES_10 RES_11 RES_12
/PRINT UNIVARIATE INITIAL CORRELATION SIG DET KMO EXTRACTION
/PLOT EIGEN
/CRITERIA MINEIGEN(1) ITERATE(25)
/EXTRACTION PAF
/ROTATION NOROTATE
/SAVE REG(ALL)
/METHOD=CORRELATION.

COMPUTE ScaledWeights0 = (R1236201*6856/1488359544).
EXECUTE.

WEIGHT BY ScaledWeights0.

MEANS TABLES=CombGS CombAR CombWK CombPC CombNO CombCS CombAI CombSI CombMK CombMC CombEI CombAO BY BHW
/CELLS MEAN COUNT STDDEV.

MEANS TABLES=RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 RES_7 RES_8 RES_9 RES_10 RES_11 RES_12 BY BHW
/CELLS MEAN COUNT STDDEV.

COMPUTE ScaledWeights1 = (R1236201*5436/1289564635).
EXECUTE.

WEIGHT BY ScaledWeights1.

PARTIAL CORR
/VARIABLES=BW RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 BY FAC1_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

PARTIAL CORR
/VARIABLES=BW RES_7 RES_8 RES_9 RES_10 RES_11 RES_12 BY FAC1_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

PARTIAL CORR
/VARIABLES=BW RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 BY FAC2_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

PARTIAL CORR
/VARIABLES=BW RES_7 RES_8 RES_9 RES_10 RES_11 RES_12 BY FAC2_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

WEIGHT BY R1236201.

PARTIAL CORR
/VARIABLES=HW RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 BY FAC1_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

PARTIAL CORR
/VARIABLES=HW RES_7 RES_8 RES_9 RES_10 RES_11 RES_12 BY FAC1_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

PARTIAL CORR
/VARIABLES=HW RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 BY FAC2_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

PARTIAL CORR
/VARIABLES=HW RES_7 RES_8 RES_9 RES_10 RES_11 RES_12 BY FAC2_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

WEIGHT BY R1236201.

PARTIAL CORR
/VARIABLES=BH RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 BY FAC1_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

PARTIAL CORR
/VARIABLES=BH RES_7 RES_8 RES_9 RES_10 RES_11 RES_12 BY FAC1_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

PARTIAL CORR
/VARIABLES=BH RES_1 RES_2 RES_3 RES_4 RES_5 RES_6 BY FAC2_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

PARTIAL CORR
/VARIABLES=BH RES_7 RES_8 RES_9 RES_10 RES_11 RES_12 BY FAC2_4
/SIGNIFICANCE=TWOTAIL
/STATISTICS=DESCRIPTIVES CORR
/MISSING=LISTWISE.

WEIGHT OFF.

GRAPH
/BAR(GROUPED)=MEAN(BW_gaps) MEAN(BW_g_partialed_out) MEAN(BW_non_g_partialed_out) BY ASVAB_subtest
/MISSING=LISTWISE.

GRAPH
/BAR(GROUPED)=MEAN(HW_gaps) MEAN(HW_g_partialed_out) MEAN(HW_non_g_partialed_out) BY ASVAB_subtest
/MISSING=LISTWISE.

GRAPH
/BAR(GROUPED)=MEAN(BH_gaps) MEAN(BH_g_partialed_out) MEAN(BH_non_g_partialed_out) BY ASVAB_subtest
/MISSING=LISTWISE.

This entry was posted in Stats, Softwares, Syntax and tagged . Bookmark the permalink.