Limiting decimal precision in calculations

Question

I currently have a very large dataset in SPSS where some variables have up to 8 decimal places. I know how to change the options so that SPSS only displays variables to 2 decimal places in the data view and output. However, SPSS still applies the 8 decimal precision in all calculations. Is there a way to change the precision to 2 decimal places without having to manually change every case?

Answer 1

You'll have to round each of the variables. You can loop through them like this:

do repeat vr=var1 var2 var3 var4 var5.
   compute vr=rnd(vr, 0.01).
end repeat.

If the variables are consecutive in the file you can use to like this:

do repeat vr=var1 to var5.
....