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.) 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
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?
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
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.