DATA Step, Macro, Functions and more

Joining tables

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

Joining tables

table 1 have input as below

code;

1

2

3

 

table 2 have input as below

item_no;

100

101

102

 

required output as

 

code item_no;

1     100
1     101
1     102
2     100
2     101
2     102
3     100
3     101
3     102

 

Any help will be really appreciated. Thank you

Thanks& Regards,
Rajiv Santosh.

Accepted Solutions
Solution
‎03-19-2018 07:12 AM
Super User
Posts: 5,829

Re: Joining tables

Cartesian SQL join will do the job.

Data never sleeps

View solution in original post


All Replies
Solution
‎03-19-2018 07:12 AM
Super User
Posts: 5,829

Re: Joining tables

Cartesian SQL join will do the job.

Data never sleeps
Occasional Contributor
Posts: 16

Re: Joining tables

Just got it . Thank you
Thanks& Regards,
Rajiv Santosh.
☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 76 views
  • 0 likes
  • 2 in conversation