DISTINCT UNION of tables

[vivek_pp]

Hi,

How do i combine 3 tables having one common field in to one single table in SAS EG using Point and Click system?

For Ex:

Table 1

Number	Column X
1	a
2	b
3	c

Table 2

Number	Column Y
1	f
2	g
3	h

Table 3

Number	Column Z
1	m
2	n
3	o

Now i want the resultant Table to be in this format.

Number	Column X	Column Y	Column Z
1	a	f	m
2	b	g	n
3	c	h	o

[Doc_Duke]

What you have described is an "inner join", not a 'distinct union'.

Inner joins of multiple tables are done using the "Query Builder" task in EGuide.  Look in the EGuide help under 'joining tables' as the process may vary slightly depending on your version of EGuide.

Doc Muhlbaier

Duke