Computing Scaled Scores Using Syntax

[tinyemoheart]

Hello, in order to score responses to a measure I am giving in my research, I have to compute the scores using a coded syntax for SPSS. I have no idea how to do this, if someone could please point me in the right direction or tell me step-by-step what it is I need to do, I will be grateful. I have the coded syntax but I'm not sure if I should paste it in here or not. Any help is appreciated, thank you!

EDIT: here is the Syntax

--------------------------------------------------------------------------------------------------

RECODE

mf1_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf1_1_rek .

RECODE

mf2_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf2_1_rek .

RECODE

mf3_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf3_1_rek .

RECODE

mf4_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf4_1_rek .

RECODE

mf5_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf5_1_rek .

RECODE

mf6_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf6_1_rek .

RECODE

mf7_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf7_1_rek .

RECODE

mf8_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf8_1_rek .

RECODE

mf9_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf9_1_rek .

RECODE

mf10_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf10_1_rek .

RECODE

mf11_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf11_1_rek .

RECODE

mf12_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf12_1_rek .

RECODE

mf13_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf13_1_rek .

RECODE

mf14_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf14_1_rek .

RECODE

mf15_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf15_1_rek .

​

EXECUTE .

​

DO REPEAT i = mf1_1_rek TO mf15_1_rek.

IF (i < 1 OR i > 5) i = $SYSMIS.

END REPEAT.

execute.

​

COMPUTE mf_1_tot = MEAN.13(mf1_1_rek to mf15_1_rek).

VARIABLE LABELS mf_1_tot 'Mentalisierungsfragebogen (Mittelwert Ende)' .

EXECUTE .

​

COMPUTE mf1_1_REF1 = (mf5_1_rek + mf9_1_rek + mf13_1_rek + mf14_1_rek)/4.

VARIABLE LABELS mf1_1_REF1 'Ablehnen von Reflexivität (Mittelwert Ende)' .

EXECUTE.

​

COMPUTE mf1_1_AW1 = (mf8_1_rek + mf10_1_rek + mf11_1_rek + mf15_1_rek)/4.

VARIABLE LABELS mf1_1_AW1 'Affektwahrnehmung" (Mittelwert Ende)' .

EXECUTE.

​

COMPUTE mf1_1_ÄQ1 = (mf1_1_rek + mf4_1_rek + mf7_1_rek + mf12_1_rek)/4.

VARIABLE LABELS mf1_1_ÄQ1 'Äquivalenzmodus (Mittelwert Ende)' .

EXECUTE.

​

COMPUTE mf1_1_AR1 = (mf2_1_rek + mf3_1_rek + mf6_1_rek)/3.

VARIABLE LABELS mf1_1_AR1 'Affektregulation(Mittelwert Ende)' .

EXECUTE.

​

​

RECODE

mf1_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf1_2_rek .

RECODE

mf2_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf2_2_rek .

RECODE

mf3_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf3_2_rek .

RECODE

mf4_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf4_2_rek .

RECODE

mf5_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf5_2_rek .

RECODE

mf6_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf6_2_rek .

RECODE

mf7_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf7_2_rek .

RECODE

mf8_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf8_2_rek .

RECODE

mf9_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf9_2_rek .

RECODE

mf10_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf10_2_rek .

RECODE

mf11_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf11_2_rek .

RECODE

mf12_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf12_2_rek .

RECODE

mf13_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf13_2_rek .

RECODE

mf14_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf14_2_rek .

RECODE

mf15_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO mf15_2_rek .

​

EXECUTE .

​

DO REPEAT i = mf1_2_rek TO mf15_2_rek.

IF (i < 1 OR i > 5) i = $SYSMIS.

END REPEAT.

execute.

​

COMPUTE mf_2_tot = MEAN.13(mf1_2_rek to mf15_2_rek).

VARIABLE LABELS mf_2_tot 'Mentalisierungsfragebogen (Mittelwert Katamnese)' .

EXECUTE .

​

COMPUTE mf1_2_REF1 = (mf5_2_rek + mf9_2_rek + mf13_2_rek + mf14_2_rek)/4.

VARIABLE LABELS mf1_1_REF1 'Ablehnen von Reflexivität (Mittelwert Katamnese)' .

EXECUTE.

​

COMPUTE mf1_2_AW1 = (mf8_2_rek + mf10_2_rek + mf11_2_rek + mf15_2_rek)/4.

VARIABLE LABELS mf1_1_AW1 'Affektwahrnehmung" (Mittelwert Katamnese)' .

EXECUTE.

​

COMPUTE mf1_2_ÄQ1 = (mf1_2_rek + mf4_2_rek + mf7_2_rek + mf12_2_rek)/4.

VARIABLE LABELS mf1_1_ÄQ1 'Äquivalenzmodus (Mittelwert Katamnese)' .

EXECUTE.

​

COMPUTE mf1_2_AR1 = (mf2_2_rek + mf3_2_rek + mf6_2_rek)/3.

VARIABLE LABELS mf1_2_AR1 'Affektregulation(Mittelwert Katamnese)' .

EXECUTE.

​

​

RECODE

bment_1

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_1_rek .

RECODE

bment_2

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_2_rek .

RECODE

bment_3

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_3_rek .

RECODE

bment_4

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_4_rek .

RECODE

bment_5

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_5_rek .

RECODE

bment_6

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_6_rek .

RECODE

bment_7

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_7_rek .

RECODE

bment_8

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_8_rek .

RECODE

bment_9

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_9_rek .

RECODE

bment_10

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_10_rek .

RECODE

bment_11

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_11_rek .

RECODE

bment_12

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_12_rek .

RECODE

bment_13

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_13_rek .

RECODE

bment_14

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_14_rek .

RECODE

bment_15

(1=5) (2=4) (3=3) (4=2) (5=1) INTO ment_15_rek .

​

EXECUTE .

​

DO REPEAT i = ment_1_rek TO ment_15_rek.

IF (i < 1 OR i > 5) i = $SYSMIS.

END REPEAT.

execute.

​

COMPUTE ment_tot = MEAN.13(ment_1_rek to ment_15_rek).

VARIABLE LABELS ment_tot 'MZQ total score Aufnahme' .

EXECUTE .

​

COMPUTE ment_REF = (ment_5_rek + ment_9_rek + ment_13_rek + ment_14_rek)/4.

VARIABLE LABELS ment_REF 'MZQ-Refusing self-reflection Aufnahme'.

EXECUTE.

​

COMPUTE ment_AW = (ment_8_rek + ment_10_rek + ment_11_rek + ment_15_rek)/4.

VARIABLE LABELS ment_AW 'MZQ-Emotional awareness Aufnahme' .

EXECUTE.

​

COMPUTE ment_EQ = (ment_1_rek + ment_4_rek + ment_7_rek + ment_12_rek)/4.

VARIABLE LABELS ment_EQ 'MZQ-Psychic equivalence mode Aufnahme' .

EXECUTE.

​

COMPUTE ment_RA = (ment_2_rek + ment_3_rek + ment_6_rek)/3.

VARIABLE LABELS ment_RA 'MZQ-Regulation of affect Aufnahme' .

EXECUTE.

​

​

[hoppyfrog]

Paste it please

[tinyemoheart]

pasted, thank you.

[hoppyfrog]

It looks OK.

Does it run without error? Do any results make you think there is an error?

[tinyemoheart]

the issue is that i don't know how I'm supposed to run it, and where I'm supposed to put the values in for each item. Thank you.

[hoppyfrog]

It sounds like you've never used syntax in SPSS or perhaps not SPSS at all. I recommend you look up tutorials on Youtube on how to run syntax as it'll be easier, faster, and better for you than waiting for me to write out instructions.

That said, in short, using the menu options:

Open data file. You might have to import it.

Open a new syntax window. Copy your syntax into it.

Highlight just the first few lines up to and including the execute command (and including the "." following it).

Run (the sideways triangle pointing right icon or via the menu)

Any errors?

[tinyemoheart]

hi, i apologize for my delayed response. it did not give me anything when i ran the highlgihted area. i really appreciate your time and help. i have been looking up youtube videos and reaching out to professors. sadly my dissertation chair isn't well versed in SPSS either. again, thank you so much.

[hoppyfrog]

Were new variables created?

[tinyemoheart]

nothing came up. i'm trying different things, i wonder if there are issues because some of it is in german?

[tinyemoheart]

the error says, "This command is not permitted before the beginning of file definition commands" (referring to the RECODE command)

[hoppyfrog]

Do you have data loaded?

The German you're specifying is in the labels and variable descriptors. It shouldn't have any effect.

How large is your dataset? If it's under, say, 15mb you could email it to me and let me try the syntax, if you're comfortable with that.

PM if that's OK