How to share tables between EG and Excel

[twelch]

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

[ChrisHemedinger]

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

[twelch]

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

Tom