BookmarkSubscribeRSS Feed
twelch
Calcite | Level 5


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

2 REPLIES 2
ChrisHemedinger
Community Manager

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

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
twelch
Calcite | Level 5

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

Tom

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1511 views
  • 3 likes
  • 2 in conversation