Will SAS egp Append Table Task take only distinct values

[devanand31]

Hi ,

Im seeing the out of the Append Table task as a distinct records of the observations.

My Append Table task has the below logic,

select * from tablea

outer union corr

select * from tableb;

if tablea is having any duplicate records, then the output of the Append Table is having only one records.

Is this the default behavior of Append Table task? Kindly advice. Thanks in advance.

Regards,

Dev
  

[Patrick]

---

@devanand31 wrote:

if tablea is having any duplicate records, then the output of the Append Table is having only one records.

Is this the default behavior of Append Table task? Kindly advice. Thanks in advance.

---

The target table will contain all rows from both source tables.

OUTER UNION CORR concatenates tables without removing any rows.

Combining Queries with Set Operators