BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
RandoDando
Pyrite | Level 9

I recently updated to a new version of EG (this never happened with the older version I had, I cannot recall what number it was but is now 8.3).  I opened my project file which has about 2 or 3 dozen programs saved in it (as individual files).  The first program I use just for assigning libnames, some of which are Oracle databases, others are file servers.  When I start a new program and try to reference a libname which works in all other programs I have, I get this error.  For file servers, it's no big issue...I just re-run the libname statement on that program.  But for the Oracle ones I use a prompt manager so that I am not breaking any security rules by hardcoding my password.  How can I get these libnames statements to work in new SAS programs?  

1 ACCEPTED SOLUTION

Accepted Solutions
BillSawyer
SAS Employee

1.) For existing projects that default to Local but you want to use another server you can use Tools > Project Maintenance which will allow you to easily select "Local" from the left side panel, then on the right panel select change in project to then select the server that you want to use throughout the project.

 

2.) For new projects and/or new programs, go to Tools > Connections > select your profile then select the Servers tab on the left side.  This window will allow you to select the default server for that profile.

 

Regards,

Bill

 

 

View solution in original post

2 REPLIES 2
RandoDando
Pyrite | Level 9

OK.  I figured out what's going on.  Apparently there are multiple servers in my SAS environment, all my existing programs were set to the correct one but the new ones have to set manually set to the correct one since they default to LOCAL.  Is there a setting to have all new programs default to the correct server?  

BillSawyer
SAS Employee

1.) For existing projects that default to Local but you want to use another server you can use Tools > Project Maintenance which will allow you to easily select "Local" from the left side panel, then on the right panel select change in project to then select the server that you want to use throughout the project.

 

2.) For new projects and/or new programs, go to Tools > Connections > select your profile then select the Servers tab on the left side.  This window will allow you to select the default server for that profile.

 

Regards,

Bill

 

 

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
  • 389 views
  • 1 like
  • 2 in conversation