topic Re: How to merge two table side by side without any common columns? in SAS Programming

How to merge two table side by side without any common columns?

Saurabh_Rana — Mon, 07 Dec 2020 07:00:47 GMT

I have two tables like these -

Table 1

Col_a Col_b

a b

a b

Table 2

Col_c Col_d

c d

c d

I want to merge these tables like this-

Table 3

Col_a Col_b Col_c Col_d

a b c d

a b c d

Kurt_Bremser — Mon, 07 Dec 2020 07:22:40 GMT

A simple data step MERGE without a BY does this.

PeterClemmensen — Mon, 07 Dec 2020 07:54:53 GMT

This is exactly what the Merge Statement does without the By Statement.