SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Merge two or more SAS datasets into Excel

Reply
Occasional Contributor
Posts: 5

Merge two or more SAS datasets into Excel

Can I "merge" two or more SAS datasets into Excel?  If so, how? 

Excel 2010

SAS Add-in 4.3

Thank you.

Esteemed Advisor
Posts: 7,293

Merge two or more SAS datasets into Excel

I think you have to better explain what you are trying to do.  You can always merge two or more datasets using either a datastep or proc sql and then export the file to Excel.

Occasional Contributor
Posts: 5

Merge two or more SAS datasets into Excel

Here's some additional detail:

I've just set up SAS-EBI 9.3 and installed MS Add-In for Excel 4.3 on a client to test.  I am exploring the functionality of the SAS tab within Excel and would like to create a filter that accesses variables from more than one SAS dataset in a SAS library. 

Thank you.

SAS Super FREQ
Posts: 8,719

Merge two or more SAS datasets into Excel

Hi:

  This sounds like a job for either an information map or a stored process.

  In the information map, you can define the relationship between the tables (one to many, one to one, etc) and the type of join. Then, the information map can be accessed by any of the client applications that support information map access. The end user will only see the "final" results and will not have to worry about the fact that what they see is the result of a join/merge process.

  Another alternative is to code you join in a stored process and return the stored process results to Excel using the SAS Add-in. The method you use will depend on what you feel comfortable with and whether you are comfortable with Information Map Studio and/or the coding needed to create a stored process.

cynthia

Occasional Contributor
Posts: 5

Merge two or more SAS datasets into Excel

Thank you Cynthia. 

I appreciate that there are various ways to create data for use in Excel.  However, in this situation I would like end users to be able to access various existing datasets via the SAS Add-in for Excel, then create a filter to refine the results. 

Esteemed Advisor
Posts: 5,198

Merge two or more SAS datasets into Excel

The two most common ways for end users to combine tables in SAS is (as Cynthia mentioned) is Information Maps (to have a power user define them for you, or if you are competent enough, do it your self), and Enterprise Guide. There is no currently available functionality in AMO to combine tables

If your users are competent enough to combine tables, I think that Enterprise Guide could be suitable tool for them.

/Linus

Data never sleeps
Ask a Question
Discussion stats
  • 5 replies
  • 1918 views
  • 0 likes
  • 4 in conversation