I have a string variable named Q6_oth that contains some open-ended
responses to a questionnaire. I ran the syntax listed below to identify
only those cases that contain text and then run a case summay report
containing the respondent ID number and the text from Q6_oth. The case
summary table is properly generated in my output but when I try to open
the pivot table containing the case summary table I get the follwoing
error message.
"SPSS 14.0 for Windows. Failed to create object. Make sure object is
entered in system registry."
Can anyone tell me how to resolve this so I can open, copy, and paste
the case summary table into an Excel spreadsheet?
Thanks.
Here's my syntax:
USE ALL.
COMPUTE filter_$=(length(rtrim(Q13_6oth))) > 0.
VARIABLE LABEL filter_$ =(length(rtrim(Q13_6oth))) > 0 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.
SUMMARIZE
/TABLES=RESP_KEY Q13_6oth
/FORMAT=VALIDLIST NOCASENUM TOTAL
/TITLE='Case Summaries'
/MISSING=VARIABLE
/CELLS=COUNT .
====================To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
