About jhzsquared

jhzsquared · ‎02-22-2017

That does work! Thank you! Do you know how you could make it into kind of a decoder key, so that you would know that IDA equals the following IDBs and IDAs that were clustered into that group? For instance with your data input it would become: Grouped ID A B 1 1 1 1 2 2 1 3

jhzsquared · ‎02-21-2017

A3 is not included because the two IDs are seperate from each other. If A3 had equaled B1, B2, or B3 then it would have been included in the grouping. However, since B4 is a new ID, it is not included. Another example would be: ID1_A ID2_B Name red apple alpha red strawberry bravo green apple charlie green strawberry bravo green banana delta purple eggplant echo becomes: ID_combined Name_combined red alpha bravo charlie bravo delta purple echo

jhzsquared · ‎02-21-2017

Hi all, I'm at a loss on how to merge/combine rows effectively when there are multiple overlapping connections. Essentially explained verbally: what I am trying to do is to take A and B and rename them by the first of the A's in the group. The problem is, A1= B1 and B2 but B2= A1 and A2. Thus, the result should just say A1= the names of B1 B2 and A2. These connections occur over multiple rows. In an example: I have: ID1_A ID2_B Name 1 1 alpha 1 2 bravo 1 3 charlie 2 2 bravo 2 3 delta 3 4 echo I want: ID_combined Name_combined 1 alpha bravo charlie bravo delta 3 echo thanks! I'm on SAS university edition

Online Status	Offline
Date Last Visited	‎03-23-2017 04:20 AM

Re: Combine rows of data with various connections across two columns

Re: Combine rows of data with various connections across two columns

Combine rows of data with various connections across two columns

Re: Combine rows of data with various connections across two columns

Re: Combine rows of data with various connections across two columns

Re: Combine rows of data with various connections across two columns

Combine rows of data with various connections across two columns