topic Re: How to share tables between EG and Excel in SAS Enterprise Guide

How to share tables between EG and Excel

twelch — Mon, 16 Apr 2012 20:26:56 GMT

First time caller.

I'm new to SAS and have successfully create several tables under the Work library through EG, but when I try to use them through the EXCEL plugin I do not see them as available.

I use the connection below:

connect to netezza

(server= xxxx database = xxxx user=me password=mypwd connection=global);

Create table weekly_report_table as

select from connection to netezza (select * from weekly_report_table order by 1,2);

Is there a way tables persistent so both sessions can see them? Or do i need to specify another more permanent library to put the tables in?

Thanks,

Tom

Re: How to share tables between EG and Excel

ChrisHemedinger — Tue, 17 Apr 2012 02:19:20 GMT

Yes, if you want to see the tables in another session (of EG or through the SAS Add-In for Office), you will need to put the tables into a permanent library.

The WORK library is temporary, and is specific to the SAS session you are working in. Each *instance* of a client application (SAS Enterprise Guide or SAS Add-In for MS Office) will create/use a *new* SAS session with its own WORK library. That's good for avoiding contention, but it restricts your ability to share "transient" data.

Chris

Re: How to share tables between EG and Excel

twelch — Thu, 19 Apr 2012 14:34:17 GMT

Thank you Chris. I had my admin setup a permanent library. (We did not have one before)

Tom