Combinatory tasks. Is it impossible?

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Wed Feb 11, 2015 5:28 pm

Combinatory tasks. Is it impossible?

Postby rofarias » Wed Feb 11, 2015 5:31 pm

I have a variable called "Conferences" and a second one called "Members". Each Conference has several Members who participate in this event. Therefore, each case has a "Member" participating into a "Conference"

What I want to do is extract a new table just with the binary relationship of "members" who participate in the same Conference.

I will give an example. Lets say we have "UN Conference 1945" with participants John, Jack, Jamie and Pablo (four cases). The table would have to give me:
John, Jack
John, Jamie
John, Pablo
Jack, Jamie
Jack, Pablo
Jamie, Pablo

I do not know If I am being clear, but I would love is someone could help me solve this puzzle.
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: Combinatory tasks. Is it impossible?

Postby GerineL » Thu Feb 12, 2015 8:57 am

Is it always in the right order?
Are the names always unique?
Are there any different columns?

If not, why not:

- sort on Variable 1.
- Use a Lag function to create a variable that holds the nr. of Johns (or whatever the name ).
- use aggregate - max function to deterimine the name that occurs most often
- add 1 to that var.

Who is online

Users browsing this forum: No registered users and 1 guest