Can I calculate with cells or groups of cells in SPSS?

[Juleke2]

<http://spssx-discussion.1045642.n5.nabble.com/file/t341365/Data_SPSS_Question.png>

This is an small example of how my actual SPSS data file looks like. I would
like to calculate the difference between 'Meas1' from 'Group' 1 and 'Meas2'
from 'Group' 2, the difference between 'Meas1' from 'Group' 2 and 'Meas2'
from 'Group' 3 and the difference between 'Meas1' from 'Group' 3 and 'Meas2'
from 'Group' 4. The answers of these calculations would be 45-20 = 25, 40-40
= 0 and 35-10 = 25. But how do I perform these calculations in SPSS? Or what
is the syntax for this type of calculation? Does anyone know? Many thanks in
advance!



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jon Peck]

Take a look at the OLAP CUBES (Analyze > Reports > OLAP Cubes) procedure.

On Mon, Jan 8, 2018 at 3:02 AM, Juleke2 <[hidden email]> wrote:

<http://spssx-discussion.1045642.n5.nabble.com/file/t341365/Data_SPSS_Question.png>

This is an small example of how my actual SPSS data file looks like. I would
like to calculate the difference between 'Meas1' from 'Group' 1 and 'Meas2'
from 'Group' 2, the difference between 'Meas1' from 'Group' 2 and 'Meas2'
from 'Group' 3 and the difference between 'Meas1' from 'Group' 3 and 'Meas2'
from 'Group' 4. The answers of these calculations would be 45-20 = 25, 40-40
= 0 and 35-10 = 25. But how do I perform these calculations in SPSS? Or what
is the syntax for this type of calculation? Does anyone know? Many thanks in
advance!



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

--

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[David Marso]

Please post TEXT examples of any data, NOT a picture.
I have mentioned this to you previously and any future posts of this nature
will be 'moderated' and not appear on the list.
http://spssx-discussion.1045642.n5.nabble.com/From-colom-to-row-with-multiple-variables-td5735318.html

Be warned.

Why are there three instances of duplicated records?
At any rate you can do this very easily with LAG and a simple computation.

IF group NE LAG (group ) Diff = Meas2-Meas1.

The calculated value wll show up in the first record of group=2,group=3 and
group=4.




Juleke2 wrote
> <http://spssx-discussion.1045642.n5.nabble.com/file/t341365/Data_SPSS_Question.png> 
>
> This is an small example of how my actual SPSS data file looks like. I
> would
> like to calculate the difference between 'Meas1' from 'Group' 1 and
> 'Meas2'
> from 'Group' 2, the difference between 'Meas1' from 'Group' 2 and 'Meas2'
> from 'Group' 3 and the difference between 'Meas1' from 'Group' 3 and
> 'Meas2'
> from 'Group' 4. The answers of these calculations would be 45-20 = 25,
> 40-40
> = 0 and 35-10 = 25. But how do I perform these calculations in SPSS? Or
> what
> is the syntax for this type of calculation? Does anyone know? Many thanks
> in
> advance!
>
>
>
> --
> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[e-mail] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD