Desktop productivity for business analysts and programmers

How to share tables between EG and Excel

Reply
Occasional Contributor
Posts: 8

How to share tables between EG and Excel


First time caller. Smiley Happy 

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

Community Manager
Posts: 2,889

Re: How to share tables between EG and Excel

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

Occasional Contributor
Posts: 8

Re: How to share tables between EG and Excel

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

Tom

Ask a Question
Discussion stats
  • 2 replies
  • 240 views
  • 3 likes
  • 2 in conversation