Cases to vars

[Ramzan Afzal]

Dear Members,

 

I am having a problem in transposing a data from tall to wide. When I use my syntax below it generates the following message.

 

CASESTOVARS

/ID = C1

/INDEX = QCode

/GROUPBY = VARIABLE .

Warnings

The INDEX values for case 362 have occurred before in the cases with the same ID values.

This command is not executed.

Any help and solution will be highly appreciated.

Regards

Ramzan

---

Express yourself instantly with MSN Messenger! MSN Messenger Download today it's FREE!

[Melissa Ives]

Ramzan,

Are your data sorted by C1 and QCode?
It sounds  like you may have a duplicate C1/QCode combination at case
362.

Melissa
________________________________

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Ramzan Afzal
Sent: Sunday, December 31, 2006 11:41 AM
To: [hidden email]
Subject: [SPSSX-L] Cases to vars

Dear Members,

I am having a problem in transposing a data from tall to wide. When I
use my syntax below it generates the following message.

CASESTOVARS

/ID = C1

/INDEX = QCode

/GROUPBY = VARIABLE .

Warnings

The INDEX values for case 362 have occurred before in the cases with the
same ID values.

This command is not executed.

Any help and solution will be highly appreciated.

Regards

Ramzan


________________________________

Express yourself instantly with MSN Messenger! MSN Messenger
<http://g.msn.com/8HMBEN/2731??PS=47575>  Download today it's FREE!


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 [phone] for assistance.

[Boyd, Christopher]

Your file needs to be properly sorted as Melissa pointed out.  Even if
you are properly sorted, you can't have a duplicate case identifiers
when running the case to variables.  You can can run an identify
duplicate cases to isolate those variables/records that will halt the
case to variables.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Melissa Ives
Sent: Tuesday, January 02, 2007 12:28 PM
To: [hidden email]
Subject: Re: Cases to vars

Ramzan,

Are your data sorted by C1 and QCode?
It sounds  like you may have a duplicate C1/QCode combination at case
362.

Melissa
________________________________

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Ramzan Afzal
Sent: Sunday, December 31, 2006 11:41 AM
To: [hidden email]
Subject: [SPSSX-L] Cases to vars

Dear Members,

I am having a problem in transposing a data from tall to wide. When I
use my syntax below it generates the following message.

CASESTOVARS

/ID = C1

/INDEX = QCode

/GROUPBY = VARIABLE .

Warnings

The INDEX values for case 362 have occurred before in the cases with the
same ID values.

This command is not executed.

Any help and solution will be highly appreciated.

Regards

Ramzan


________________________________

Express yourself instantly with MSN Messenger! MSN Messenger
<http://g.msn.com/8HMBEN/2731??PS=47575>  Download today it's FREE!


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 [phone] for assistance.

**********************************************************************
Sent from the New York City Office of the Comptroller. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. This footnote also confirms that this email message has been swept for the presence of computer viruses.
**********************************************************************