The SAS Output Delivery System and reporting techniques

Merging Uncommon Tables

Accepted Solution Solved
Reply
Regular Contributor
Posts: 220
Accepted Solution

Merging Uncommon Tables

I have 2 tables that have nothing in common, but I want to merge them together.  I think an illustration will work better than trying to explain it:

Table 1

ID
0001
0002
0003
0004
0005
0006

Table 2

Color
Red
Yellow
Green

Desired Table

IDColor
0001Red
0001Yellow
0001Green
0002Red
0002Yellow
0002Green
0003Red
0003Yellow
0003Green
0004Red
0004Yellow
0004Green
0005Red
0005Yellow
0005Green
0006Red
0006Yellow
0006Green

Accepted Solutions
Solution
‎07-12-2013 03:52 PM
Grand Advisor
Posts: 17,491

Re: Merging Uncommon Tables

Lookup cross join

View solution in original post


All Replies
Solution
‎07-12-2013 03:52 PM
Grand Advisor
Posts: 17,491

Re: Merging Uncommon Tables

Lookup cross join

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 233 views
  • 0 likes
  • 2 in conversation