topic Re: LIBNAME not assigned error when starting a new program in SAS Enterprise Guide

LIBNAME not assigned error when starting a new program

RandoDando — Wed, 30 Jul 2025 12:38:45 GMT

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?

Re: LIBNAME not assigned error when starting a new program

RandoDando — Wed, 30 Jul 2025 12:42:23 GMT

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?

Re: LIBNAME not assigned error when starting a new program

BillSawyer — Wed, 30 Jul 2025 15:38:36 GMT

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