Calcite | Level 5

## How to combine tables

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

Student | Math | English | Science | Math National Avg | English National Avg | Science National Avg

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: How to combine tables

``````Data want;
If _n_ = 1 then set table2;

Set table1;

Run;``````

Try this.

4 REPLIES 4
Diamond | Level 26

## Re: How to combine tables

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

```data want;
merge table1 table2;
run;```
Calcite | Level 5

## Re: How to combine tables

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

Student | Math | English | Science | Math National Avg | English National Avg | Science National Avg

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

Super User

## Re: How to combine tables

``````Data want;
If _n_ = 1 then set table2;

Set table1;

Run;``````

Try this.

Diamond | Level 26

## Re: How to combine tables

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;```
Discussion stats
• 4 replies
• 1304 views
• 0 likes
• 3 in conversation