Combining variables/frequencies

[Heather Blunt]

Hello,

I'm wondering if there is any syntax that can produce the outcome I'm
looking for:

I have a data set in which each respondent provides information about up
to 3 partners. The questions asked about each of these partners are the
same (e.g., how old is the partner, where did you meet them, etc). In the
dataset, each of the variables for each partner is separate. For example,
I have a separate variable for "how old is partner 1", "how old is partner
2" and "how old is partner 3". I would like to be able to analyze these
variables with the data for partner 1, 2, and 3 combined for each
variable. For example, I'd like to be able to analyze how old partners
were as a whole, rather than separately for partners 1, 2, and 3.

Right now, when I run frequencies I have separate frequencies for each
variable for partner 1, 2, and 3. I'd like to get an overall frequency,
without manually adding the frequencies together for each partner. Is
there a way to do this in SPSS?

Thanks in advance!
Heather

=====================
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

[Spousta Jan]

Hi Heather,

There are two ways how to handle it:

1) Using multiple response (see Analyze -> Multiple response): define sets of similar variables and get tables for the whole sets

2) Restructuring of the data (see Data -> Restructure...): Each respondent will have up to 3 rows in the transformed data, according to the number of his/her partners. Then you can use standard techniques of tabelation.

HTH

Jan

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Heather Blunt
Sent: Friday, June 26, 2009 4:05 PM
To: [hidden email]
Subject: Combining variables/frequencies

Hello,

I'm wondering if there is any syntax that can produce the outcome I'm looking for:

I have a data set in which each respondent provides information about up to 3 partners. The questions asked about each of these partners are the same (e.g., how old is the partner, where did you meet them, etc). In the dataset, each of the variables for each partner is separate. For example, I have a separate variable for "how old is partner 1", "how old is partner 2" and "how old is partner 3". I would like to be able to analyze these variables with the data for partner 1, 2, and 3 combined for each variable. For example, I'd like to be able to analyze how old partners were as a whole, rather than separately for partners 1, 2, and 3.

Right now, when I run frequencies I have separate frequencies for each variable for partner 1, 2, and 3. I'd like to get an overall frequency, without manually adding the frequencies together for each partner. Is there a way to do this in SPSS?

Thanks in advance!
Heather

=====================
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



_____________
Tato zpráva a všechny připojené soubory jsou důvěrné a určené výlučně adresátovi(-ům). Jestliže nejste oprávněným adresátem, je zakázáno jakékoliv zveřejňování, zprostředkování nebo jiné použití těchto informací. Jestliže jste tento mail dostali neoprávněně, prosím, uvědomte odesilatele a smažte zprávu i přiložené soubory. Odesilatel nezodpovídá za jakékoliv chyby nebo opomenutí způsobené tímto přenosem.

Jste si jisti, že opravdu potřebujete vytisknout tuto zprávu a/nebo její přílohy? Myslete na přírodu.


This message and any attached files are confidential and intended solely for the addressee(s). Any publication, transmission or other use of the information by a person or entity other than the intended addressee is prohibited. If you receive this in error please contact the sender and delete the message as well as all attached documents. The sender does not accept liability for any errors or omissions as a result of the transmission.

Are you sure that you really need a print version of this message and/or its attachments? Think about nature.

-.- --

=====================
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