DISTINCT UNION of tables

vivek_pp — Mon, 19 Mar 2012 13:49:01 GMT

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

DISTINCT UNION of tables

Doc_Duke — Mon, 19 Mar 2012 15:45:37 GMT

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

topic DISTINCT UNION of tables in SAS Enterprise Guide

DISTINCT UNION of tables

DISTINCT UNION of tables