Desktop productivity for business analysts and programmers

How to union two data sets

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

How to union two data sets

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!

 

Untitled.png


Accepted Solutions
Solution
‎03-28-2016 04:01 AM
Esteemed Advisor
Posts: 6,646

Re: How to union two data sets

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Super User
Posts: 1,098

Re: How to union two data sets

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?

Occasional Contributor
Posts: 5

Re: How to union two data sets

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.

Solution
‎03-28-2016 04:01 AM
Esteemed Advisor
Posts: 6,646

Re: How to union two data sets

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 1392 views
  • 1 like
  • 3 in conversation