topic Re: How to union two data sets in SAS Enterprise Guide

How to union two data sets

derickloo — Fri, 25 Mar 2016 06:20:22 GMT

I has 2 database which has the same table structure. I want union the dataset been generate by the query builder in the same Process flow. I has select table from database A and run the query builder to generate the dataset. In the same project, I also select table from database B and generate the dataset. I need to union both dataset become one dataset, and I need upload the final dataset to LASR.

May I know how I can make this work? Please help. Thanks!

Re: How to union two data sets

JuanS_OCS — Fri, 25 Mar 2016 07:49:56 GMT

Hi,

I am not sure to fully understand you, but I let me give it a shot.

What I think you are looking for is:

- to create a new Query Builder of your 2 generated tables, so you can create the union

- and add an additional step to load the data into LASR.

Are those 2 steps clear or any is not clear to you?

Re: How to union two data sets

derickloo — Fri, 25 Mar 2016 08:21:00 GMT

Ya...I wish to union the table generate by Query builder with the table generate by Query builder(2); and then upload it to LASR. May I know how I perform this beside using program?

Thanks.

Re: How to union two data sets

Kurt_Bremser — Fri, 25 Mar 2016 08:31:32 GMT

In Enterprise Guide, you find a "Append Table" task that does a UNION in PROC SQL.