Date:         Wed, 28 Jul 2004 16:39:06 +0200
Reply-To:     Spousta Jan <JSpousta@CSAS.CZ>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Spousta Jan <JSpousta@CSAS.CZ>
Subject:      Re: mean in tables
Comments: To: "Stefan.H.Jonsson@parx.is" <Stefan.H.Jonsson@parx.is>
Content-Type: text/plain; charset="UTF-8"

Hello Stefan,

You can insert something like this before the TABLES command:

do repe x = x20 to x65 /*here the real list of your variables */.
comp x = 6 - x.
* reverses the scale.
end repe.

And the same piece of code _after_ the last TABLES command with means in order to switch the scales into the original form.

Which can be done every week.

Even more correct is to compute new variables (reverted scales) using:

do repe x = x20 to x65 / rev = r20 to r60.
comp rev = 6 - x.
end repe.

Labeling them etc. and perhaps delete them after finishing the task.

HTH

Jan

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Stefan Jonsson
Sent: Wednesday, July 28, 2004 4:26 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: mean in tables


Hello


I have a table command like this:

TABLES
  / missing = exclude
  /GBASE=CASES
  /FTOTAL=$T000001 "Total"
  /TABLE= x01 + x02 + x03
  BY x20 + $t000001
  /STATISTICS
  mean( $T000001(F5.2 )'Mean')
  median( $T000001(F5.2 )'Median')
  stddev( $T000001(F5.2 )'Std.dev.')
  count( $T000001( F5.0 )'N')
  cpct( x20 ( pct5.1 ) '': x01  x02 x03)
  /corner 'Text'.




Due to questionnaire design and data entry, the coding of variable x20 is
reversed ( a Lickert scale  1 thru 5)  compared to what I really want.
What I want is to display reversed mean in the table  [ 6 - mean (x20) ]


I know I could recode the variables and recreate the labels. But I have 45
more variables like  x20 to display the mean for and I expect to do this
weekly

Preferably I would like to have the table command like below (note the 6-
with median and mean) Since the value labels are reported not the values
this will work fine.
Unfortunately this does not work which brings me to the question.

THE QUESTION: Is there a short way to let the table command display the
"reversed mean”?



TABLES
  / missing = exclude
  /GBASE=CASES
  /FTOTAL=$T000001 "Total"
  /TABLE= x01 + x02 + x03
  BY x20 + $t000001
  /STATISTICS
  6-mean( $T000001(F5.2 )'Mean')
  6-median( $T000001(F5.2 )'Median')
  stddev( $T000001(F5.2 )'Std.dev.')
  count( $T000001( F5.0 )'N')
  cpct( x20( pct5.1 ) '': x01  x02 x03)
  /corner 'Text'.