BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
KarenGeurts
Calcite | Level 5

I have a dataset with 2 columns of ID numbers (id1 id2). Each row establishes a link between 2 ID numbers There are several many-to-many links, and some ID numbers appear in both columns. I want to create a "group-ID" for all IDs which are interlinked with each other. How can I do this?

In the example below, I want to create 2 group IDs: one for ID numbers a b c d, and another for ID numbers e f.

data have;

input (id1 id2) (:$1.);

cards;

a b

a c

b d

e f

;

Thanks for your help.

Karen

1 ACCEPTED SOLUTION

Accepted Solutions
7 REPLIES 7
Reeza
Super User

If you have SAS/OR licensed then look at PROC BOM.

If not, there's a good solution posted on here earlier that some searching may help find.

KarenGeurts
Calcite | Level 5

Thank for your answer, but I do not have SAS/OR.

I used the macro SubGraphs as suggested by PG, which works very well

Karen

Reeza
Super User

I don't have SAS/OR anymore either, so I'm glad to see PG's macro as well!

PGStats
Opal | Level 21

This can be done with my SubGraphs macro. See

 

How to find all connected components in a graph

 

PG

PG
KarenGeurts
Calcite | Level 5

It works wonderfully.

Thank you very much

Karen

Reeza
Super User

@ChrisHemedinger

Where would this document now exist?

 

ChrisHemedinger
Community Manager

@Reeza - I fixed the link to point to the proper article.

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1238 views
  • 2 likes
  • 4 in conversation