topic Re: How to combine tables in SAS Procedures

How to combine tables

ernie86 — Mon, 18 Apr 2016 14:46:01 GMT

TABLE 1.

Student | Math | English | Science

Sue 3.5 6.0 2.1

Amy 3.7 5.3 2.8

Cindy 2.9 5.8 3.5

Kevin 3.2 6.2 2.1

TABLE 2.

Math National Avg | English National Avg | Science National Avg

3.6 6.1 3.8

TABLE WANT

Sue 3.5 6.0 2.1 3.6 6.1 3.8

Amy 3.7 5.3 2.8 3.6 6.1 3.8

Cindy 2.9 5.8 3.5 3.6 6.1 3.8

Kevin 3.2 6.2 2.1 3.6 6.1 3.8

I want to combine table 1 and table 2 to create table want. I don't know how to combine tables without an unique idenitifier. Someone please help.

Re: How to combine tables

RW9 — Mon, 18 Apr 2016 14:48:55 GMT

Something like this (not tested - for tested code post test data in the form of a datastep):

data want;
  merge table1 table2;
run;

Re: How to combine tables

ernie86 — Mon, 18 Apr 2016 14:57:56 GMT

I already tried this, and it didn't work. It came out like this:

Sue 3.5 6.0 2.1

Amy 3.7 5.3 2.8

Cindy 2.9 5.8 3.5

Kevin 3.2 6.2 2.1

3.6 6.1 3.8

Re: How to combine tables

Reeza — Mon, 18 Apr 2016 15:09:50 GMT

Data want;
If _n_ = 1 then set table2;

Set table1;

Run;

Try this.

Re: How to combine tables

RW9 — Mon, 18 Apr 2016 15:15:50 GMT

This shold work:

data a;
  a=1; output;
  a=2; output;
run;
data b;
  c=1;
run;
proc sql;
  create table WANT as
  select *
  from   A
  full join B
  on     1=1;
quit;