Removing duplicate values in cases

[prasad]

CONTENTS DELETED

The author has deleted this message.

[Bruce Weaver]

I think you mean "within" cases rather than among.  Here's one option:

1. Restructure from wide to long with VARSTOCASES.
2. Flag and delete duplicate cases (Data - Identify Duplicate Cases).
3. Restructure back to wide format (CASESTOVARS)

Alternatively, you could do something with VECTOR & LOOP in the original wide format.

HTH.

prasad wrote

Hi folks,

CASE1 A419 N309 N179 N1891 I214 Z509 M545 M161 M8199 F059 N179 K590 Z509 N390 B961 A419
CASE2 J440 E1180 Z922 Z8643 E1160 E1160 CS509 S6081 J440


How do I delete dupliate values among cases. Please see example above.

Thank you for your help.
Prasad

[David Marso]

If this is the same data as last week then you are better deduping a long structure than a wide one.
Think AGGREGATE or a SORT followed by MATCH (see FIRST and LAST) or LAG.  I leave it to you to think about this and sort out the details rather than just hand you a fish.
--

prasad wrote

Hi folks,

CASE1 A419 N309 N179 N1891 I214 Z509 M545 M161 M8199 F059 N179 K590 Z509 N390 B961 A419
CASE2 J440 E1180 Z922 Z8643 E1160 E1160 CS509 S6081 J440


How do I delete dupliate values among cases. Please see example above.

Thank you for your help.
Prasad

[David Marso]

"Alternatively, you could do something with VECTOR & LOOP in the original wide format. "
A truly hellish proposition ;-)

Bruce Weaver wrote

I think you mean "within" cases rather than among.  Here's one option:

1. Restructure from wide to long with VARSTOCASES.
2. Flag and delete duplicate cases (Data - Identify Duplicate Cases).
3. Restructure back to wide format (CASESTOVARS)

Alternatively, you could do something with VECTOR & LOOP in the original wide format.

HTH.

prasad wrote

Hi folks,

CASE1 A419 N309 N179 N1891 I214 Z509 M545 M161 M8199 F059 N179 K590 Z509 N390 B961 A419
CASE2 J440 E1180 Z922 Z8643 E1160 E1160 CS509 S6081 J440


How do I delete dupliate values among cases. Please see example above.

Thank you for your help.
Prasad

[Søren Bech]



Hi

 

I am not in the office right now - I will be back Monday October 22nd and respond to your mail

 

Best regards

Søren

 

[prasad]

Thanks Bruce,

Yes, within cases. Will try VARSTOCASES and restructure back.

Prasad

---

From: Bruce Weaver [via SPSSX Discussion] [ml-node+[hidden email]]
Sent: Monday, 15 October 2012 10:27 PM
To: Prasad Nishtala
Subject: Re: Removing duplicate values in cases

I think you mean "within" cases rather than among.  Here's one option:

1. Restructure from wide to long with VARSTOCASES.
2. Flag and delete duplicate cases (Data - Identify Duplicate Cases).
3. Restructure back to wide format (CASESTOVARS)

Alternatively, you could do something with VECTOR & LOOP in the original wide format.

HTH.

prasad wrote

Hi folks,

CASE1 A419 N309 N179 N1891 I214 Z509 M545 M161 M8199 F059 N179 K590 Z509 N390 B961 A419
CASE2 J440 E1180 Z922 Z8643 E1160 E1160 CS509 S6081 J440


How do I delete dupliate values among cases. Please see example above.

Thank you for your help.
Prasad

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Removing-duplicate-values-in-cases-tp5715639p5715643.html

To unsubscribe from Removing duplicate values in cases, click here.
NAML

[prasad]

Thanks David,

I will work out the rest.

Cheers Prasad

---

From: David Marso [via SPSSX Discussion] [ml-node+[hidden email]]
Sent: Monday, 15 October 2012 10:29 PM
To: Prasad Nishtala
Subject: Re: Removing duplicate values in cases

If this is the same data as last week then you are better deduping a long structure than a wide one.
Think AGGREGATE or a SORT followed by MATCH (see FIRST and LAST) or LAG.  I leave it to you to think about this and sort out the details rather than just hand you a fish.
--

prasad wrote

Hi folks,

CASE1 A419 N309 N179 N1891 I214 Z509 M545 M161 M8199 F059 N179 K590 Z509 N390 B961 A419
CASE2 J440 E1180 Z922 Z8643 E1160 E1160 CS509 S6081 J440


How do I delete dupliate values among cases. Please see example above.

Thank you for your help.
Prasad

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Removing-duplicate-values-in-cases-tp5715639p5715644.html

To unsubscribe from Removing duplicate values in cases, click here.
NAML

[sdubois]

Also, Raynald has a posting (from David) that addresses this. See the link below for David's solution. I believe the first solution that David provides should do it - without the final compute (that tally's the responses).

http://www.spsstools.net/Syntax/MultipleResp/CountUniqueOccurencesOfAMultipleResponse.txt

Sach

[prasad]

<sup>Hi Sach,

Managed to solve it as per David's input.
Thanks
Prasad</sup>

---

From: sdubois [via SPSSX Discussion] [ml-node+[hidden email]]
Sent: Wednesday, 17 October 2012 2:45 AM
To: Prasad Nishtala
Subject: RE: Removing duplicate values in cases

Also, Raynald has a posting (from David) that addresses this. See the link below for David's solution. I believe the first solution that David provides should do it - without the final compute (that tally's the responses).

http://www.spsstools.net/Syntax/MultipleResp/CountUniqueOccurencesOfAMultipleResponse.txt

Sach

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Removing-duplicate-values-in-cases-tp5715639p5715677.html

To unsubscribe from Removing duplicate values in cases, click here.
NAML