How do i Insert rows to existing table

[shlomiohana]

Hello,

I want to insert these 2 rows to every line in my table.

group	company
2	22
3	31

table:

bank	branch	number_card
20	1	333
20	2	444

final table:

bank	branch	number_card	group	company
20	1	333	2	22
20	1	333	3	31
20	2	444	2	22
20	2	444	3	31

How can I do that?

Thanks.

[ghosh · Accepted solution]

use a cartesian join

proc sql;
  create table want as
     select *
        from two, one
        ;
quit;
proc print;
run;

Untitled.png

[Reeza]

Is the items in your first set in a data set?

If not put them in a data set or use a data step. Putting them in a data step is a more dynamic approach. 

data want;
set sashelp.class;

group=1; company=22; output;
group=3; company=31; output;

run;

Or

data t1;
input group company;
cards;
1 22
3 31
;;;;

Then use the approach provided by @ghosh