Date: Wed, 16 Jan 2008 18:03:35 -0500
Reply-To: Anton <antonstatistics@HOTMAIL.COM>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Anton <antonstatistics@HOTMAIL.COM>
Subject: Re: Restructuring a fuzzy matched data set
Sorry for the confusion. My explanation of what I have and what I need
probably wasn't clearly articulated.
I have the following SPSS data set with two columns: Match# and ID. What
Match# 1 this tells me in the following data set is that ID 27 and ID 42 are
linked or are matched. Match# 2 tells me that ID 27 and ID 53 are linked.
Match# 4 tells me that ID 42 and ID 53 are linked, and so on. So,
logically, I know that Ids 27, 42 & 53 are linked to each other, as are 18
and 99.
Match# ID
1 27
1 42
2 27
2 53
3 18
3 99
4 42
4 53
I need a data set that takes the all of the IDs that are linked or matched
and put them on the same row:
VAR1 VAR2 VAR3
27 42 53
18 99
BTW: I don't have/use python.
Thanks again for any guidance.
Anton
On Wed, 16 Jan 2008 15:26:04 -0500, Gene Maguin <emaguin@buffalo.edu> wrote:
>Anton,
>
>I don't know if there is an alternative. You mentioned a CDC program. I am
>not familiar with it. I guess I also don't understand (or misunderstood) the
>process. I assumed that you passed your dataset through the CDC program and
>it produced a dataset structured as shown in your example. In your example
>the variable Name defined sets of cases. It sounds like you are now saying
>that Name does not uniquely identify sets of cases. How can you identify
>sets of cases? I think that is THE question.
>
>Gene Maguin
>
>=====================
>To manage your subscription to SPSSX-L, send a message to
>LISTSERV@LISTSERV.UGA.EDU (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
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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
