Desktop productivity for business analysts and programmers

DISTINCT UNION of tables

Reply
N/A
Posts: 1

DISTINCT UNION of tables

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

2b
3c

Table 2

NumberColumn Y
1f
2g
3h

Table 3

Number
Column Z
1m
2n
3o

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

NumberColumn XColumn YColumn Z
1afm
2bgn
3cho
Trusted Advisor
Posts: 2,114

DISTINCT UNION of tables

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

Ask a Question
Discussion stats
  • 1 reply
  • 242 views
  • 0 likes
  • 2 in conversation