Date:         Tue, 2 Sep 2003 11:44:09 -0400
Reply-To:     Sylvain.Labrie@bnc.ca
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Sylvain Labrie <Sylvain.Labrie@bnc.ca>
Subject:      Help with syntax
Content-Type: text/plain; charset="us-ascii"

Good morning to you all, I would need any assistance with the following
question.

We have designed a organizational climate survey for the employees where I
work. The 25 or so items use a 5 point scale of agreement where 1 equals
to TOTAL DISAGREEMENT and 5 equals to TOTAL AGREEMENT. The more than 9000
respondents are divided into groups corresponding to the organizations
administrative units. We wish to prepare a report with tables that would
show the following information.

1- We want to produce unit specific reports.
2- For each chosen unit, we have to produce one single table that would
show for every individual item the number and percentage of respondents
that have answered 4 as well as the number and percentage of respondents
having answered 5.

I have no problem with the isolation of the cases (choosing the units) but
I have hit a dead end with the syntax for the production of the data and
the needed tables. I have tried SELECT IF procedures with answers 4 and 5
as criterion but that selection turns out to affect the true percentage of
respondents given that the respondents having answered 1, 2 or 3 are
excluded of the descriptive statistics. And I dare not mention the result
I got when I tried to build a table with the data.

Many thanks for sharing your wisdom.

If it were appropriate, I would like to suggest responding directly to me
at sylvain.labrie@bnc.ca and once I have found the functional answer to my
question, I shall post it to the group.

Very best regards, Sylvain.