Page 1 of 1

Changing Levels of a Variable

Posted: Mon Nov 01, 2021 9:40 am
by Raffael
Hello everyone,
I have a problem concerning the analyzation of my data. I use a Questionnaire that uses a total score and the points ranges from 0 to 3. The problem is that my levels for that variables goes from 1 to 4. That means when I try to sum up the score I get false numbers. My question is how can I change the levels from 1-4 to 0-3?

Thank you

Re: Changing Levels of a Variable

Posted: Mon Nov 01, 2021 2:04 pm
by MAgojam
Hi @Raffael,
in the Data menu you have Compute and Transform.

Let's assume that you have the following 5 variables (Q1, Q2, Q3, Q4, Q5) and you are interested in having a QTot variable as a sum for each case, you can use the Compute using the SUM() function to subtract the number of variables added.
In the case of ex. above, you should do this:
= SUM(Q1, Q2, Q3, Q4, Q5, ignore_missing=0) - 5
(If there is even one missing, there will be no total)

With Transform you can create (even in a single step) new recoded variables.
First select all the variables you want to transform, then transform and to the $source you will add -1 like this:
= $source - 1

Hope the above is what you are interested/need.
Cheers,
Maurizio