Use the \AUTOFIX=No subcommand. That will force the multiple variables
for q3.
If you DO have some variables that don't change (e.g. Gender) you can
set those with the \FIXED=gendervar subcommand.
Melissa
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of
Eugenio Grant
Sent: Friday, November 24, 2006 6:02 PM
To:
[hidden email]
Subject: [SPSSX-L] CASESTOVARS Problem!!!
Hi Listserv:
I have the following code and it's not working:
* CODE BEGINS.
DATA LIST FREE /ncuest q1 q2 q3.
BEGIN DATA
1 4 7 1
1 7 10 1
1 8 14 1
2 11 22 1
2 18 21 1
2 7 7 1
END DATA.
SORT CASES BY ncuest.
CASESTOVARS
/ID = ncuest
/GROUPBY = variable.
* END OF CODE.
As you can see q3 has the same values, in my results this could be
either missing values on every case. As I try to create a cases to var I
expect
this:
( Q1.1, Q2.1, Q3.1, Q1.2, Q2.2, Q3.2, Q1.3, Q2.3, Q3.3) instead I'm
getting (Q3, Q1.1, Q2.1, Q1.2, Q2.2, Q1.3, Q2.3).
I have to conform to a specific format for the client so even if a
variable has the same value or no value. I need to have all the needed
values even if they might have no values or the same value.
How can I tell SPSS to generate all the needed values even if they don't
change values.
Thanks!!!
PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at (309) 827-6026 for assistance.
Locked
