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
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
Thank you Chris. I had my admin setup a permanent library. (We did not have one before)
Tom
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.