Merging table

[Shirin]

NO it doesn't, I keep getting blanks.

[Kurt_Bremser]

data table1;

input ID Var1 Var2;

cards;

1 1 1

1 2 2

1 3 3

2 1 1

2 2 2

3 1 1

3 2 2

3 3 3

3 4 4

;

run;

data table2;

input ID VarA $;

cards;

1 x

2 u

3 h

;

run;

data table3;

merge table1 table2;

by ID;

run;

proc print;run;

gets this output:

Obs

ID

Var1

Var2

VarA

1	1	1	1	x
2	1	2	2	x
3	1	3	3	x
4	2	1	1	u
5	2	2	2	u
6	3	1	1	h
7	3	2	2	h
8	3	3	3	h
9	3	4	4	h