04-16-2012 04:26 PM
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?
04-16-2012 10:19 PM
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.