topic Re: Combining two tables with different no. of columns in SAS Programming

Combining two tables with different no. of columns

jeka1212 — Mon, 12 Mar 2018 02:52:01 GMT

Hi all,

I am having problem in combining two tables with different no. of columns.

Now if I type command:

data table3;
                 set tabel1 table2;
                 run;

I dont have the table3 I want.

Any help i can have table3 like this?

novinosrin — Mon, 12 Mar 2018 03:17:40 GMT

Are you looking for one to one merge?

data want;

set table1;

set table2;

run;

data want;

merge table1 table2;

run;

jeka1212 — Mon, 12 Mar 2018 10:19:40 GMT

Many thanks Proc Star. Much appreciated