topic How do i Insert rows to existing table in SAS Programming

How do i Insert rows to existing table

shlomiohana — Mon, 10 Aug 2020 17:50:41 GMT

Hello,

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

table:

final table:

How can I do that?

Thanks.

ghosh — Mon, 10 Aug 2020 18:16:49 GMT

use a cartesian join

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

Reeza — Mon, 10 Aug 2020 19:04:17 GMT

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;

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

Then use the approach provided by @ghosh