topic Will SAS egp Append Table Task take only distinct values in SAS Enterprise Guide

Will SAS egp Append Table Task take only distinct values

devanand31 — Sat, 07 Jan 2023 17:25:58 GMT

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

Re: Will SAS egp Append Table Task take only distinct values

Patrick — Sun, 08 Jan 2023 01:29:10 GMT

@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