Date:         Thu, 7 Dec 2006 07:03:19 -0600
Reply-To:     "Beadle, ViAnn" <viann@spss.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Beadle, ViAnn" <viann@spss.com>
Subject:      Re: Print survey item text and responses for one
Comments: To: Dennis Deck <DDeck@rmccorp.com>
In-Reply-To:  A<EFCF16377594714C9B2B3A8CFC31615D618158@svrmail.RMC.local>
Content-Type: text/plain; charset="us-ascii"

Try summarize which will create a pivot table of cases as rows and columns as variables and then activate the table and flip it.

Make sure your settings are as follows:
No draft viewer.
Display values as Labels on the Output tab in Options.
Display variables as Names on the Output tab in Options.

SUMMARIZE varlist / format list nototal.

Double-click on the table to activate it. Go to the Pivot menu and select Transpose Rows and Columns.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Dennis Deck
Sent: Wednesday, December 06, 2006 11:50 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Print survey item text and responses for one

I have a school survey with about 50 multiple choice items with VALUE
LABELS.  I need to print the responses for all the items for selected
cases.  Thus I need to display the text of each item and the value
labels for the selected choice rather than the numeric code.  Ideally I
would like to have the items as rows and responses for 1 or more schools
as columns.

a) REPORT provides control over whether you displaying the label or
numeric value but wants to display variables as columns not rows.

b) PRINT or WRITE provide flexibility in displaying a text string with
the item stem and a response but display the value not the label.

c) I considered using CASETOVARS to restructure the data and merge with
a data dictionary of item and choice labels but that would take some
time to build and test.

Any creative suggestions?


Dennis Deck, PhD
RMC Research Corporation
111 SW Columbia Street, Suite 1200
Portland, Oregon 97201-5843
voice: 503-223-8248 x715
voice: 800-788-1887 x715
fax:  503-223-8248
ddeck@rmccorp.com