Hi Anthony,
You want to use the absolute function ABS(variable). I searched the archives and here is a post from Art Kendall that has the solution.
Hope this helps,
Ariel
http://listserv.uga.edu/cgi-bin/wa?A2=ind0812&L=spssx-l&P=R28075
*************************************************************************
open a clean instance of SPSS.
Copy the syntax below and paste it into a syntax window.
click <run> <all>.
If this is not what you want please explain in more detail, perhaps
making up a set of data with 2 columns: what you have and what you want.
data list list /myvar (comma8.2).
begin data
2,155.00
2,155.00
1,080.00
1,830.00
1,030.00
2,155.00
1,130.00
-2,155.00
-2,155.00
-1,080.00
-1,830.00
-1,030.00
-2,155.00
-1,130.00
end data.
compute myabsvar= abs(myvar).
LIST .
Art Kendall
Social Research Consultants
*************************************************************************
On Sat, Jun 16, 2012 at 12:26 AM, Anthony James <
[hidden email]> wrote:
>
> Dear colleagues,
> I want to get the absolute value of a variable in SPSS. That is, I want to get read of the negative sing next to some values and compute the mean of the values. I want to change all the negative values to positive.
> What should I do?
> Thanks
> Anthony