EG and SQL and UNION

[JohnH]

Is there a reason why the Query Builder (PRCO SQL) in EG does not have the UNION option in the point & click system or is that a feature that SAS is working on for a later version of EG? Thanks

[RichardH_sas]

You can use the OUTER UNION CORR in a point-and-click way via the task Append Data. I think the demand for the set operators from within the query builder hasn't been that high yet, though it's possible they will be included in a future version of EG.

[Patrick]

Demand, demand!
I would like to have ONE wizard for combining tables via SQL - whether this is a JOIN or a UNION - and things like EXIST would be nice as well.

[goat]

i second the demand. why a separate task for standard SQL functionality?