Merging tables which have no common column

SASuser4321 — Wed, 30 Nov 2022 07:32:39 GMT

Hi, I have 3 tables. This is how they look like:

Changes

2.56%

No_changes

5.12%

Weights

1.12%

I would like to merge these tables in a way so that they look like this:

Changes	No_changes	Weights
2.56%	5.12%	1.12%

I tried the following code but it ends up stacking them top to bottom instead of merging them left to right as shown above:

data final ;
set Table_1 Table_2 Table_3;
run;

Help would be appreciated. Thanks.

Re: Merging tables which have no common column

PeterClemmensen — Wed, 30 Nov 2022 07:43:50 GMT

What you want is a Merge Statement with no By Statement.

data want;
   merge Table_1 Table_2 Table_3;
run;