Desktop productivity for business analysts and programmers

EG and SQL and UNION

Reply
Contributor
Posts: 73

EG and SQL and UNION

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
SAS Employee
Posts: 149

Re: EG and SQL and UNION

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.
Respected Advisor
Posts: 3,837

Re: EG and SQL and UNION

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.
Contributor
Posts: 29

Re: EG and SQL and UNION

i second the demand. why a separate task for standard SQL functionality?
Ask a Question
Discussion stats
  • 3 replies
  • 2560 views
  • 1 like
  • 4 in conversation