topic Joining tables in SAS Programming

Joining tables

rajiv436 — Mon, 19 Mar 2018 10:51:22 GMT

table 1 have input as below

code;

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

LinusH — Mon, 19 Mar 2018 11:08:16 GMT

Cartesian SQL join will do the job.

rajiv436 — Mon, 19 Mar 2018 11:12:40 GMT

Just got it . Thank you