topic Reassigning Libnames in SAS Enterprise Guide

Reassigning Libnames

LAP — Tue, 01 May 2007 15:19:13 GMT

I am running macro in EG that reassigns the same libname at each iteration. At the end of the previous run I attempt to clear the libname (libname _project clear;) but get the following error.

ERROR: Unable to clear or re-assign the library _PROJECT because it is still in use.
ERROR: Error in the LIBNAME statement.

Why? How do I circumvent this error?

Thanks

Re: Reassigning Libnames

Olivier — Wed, 02 May 2007 10:42:43 GMT

Hello.

My own experience of the problem (far from extensive) is related to having macro-programs stored in that library, in a catalog ; the library cannot be desassigned until the end of the SAS session.

As a circumvention : since you are iterating in your macro program, this sounds like you're using a macro loop. You can test the iteration number and only assign the library once (and desassign it once at the very end of your iterations) :

%DO loop_index = 1 %TO 1000 ;
%IF &loop_index = 1 %THEN %DO ;
LIBNAME _project "my library path" ;
%END ;
...
%IF &loop_index = 1000 %THEN %DO ;
LIBNAME _project CLEAR ;
%END ;
%END ;

Regards.
Olivier

Reassigning Libnames

pcavicch — Tue, 02 Aug 2011 11:36:45 GMT

I haven't found an elegant solution, but I'm using this code in Enterprise Guide:

*-- start code --;

data _NULL_;

length WORD $8;

do j = 1 to 8;

WORD = byte(int(65 + ranuni(0)*26)) || WORD;

end;

call symput("mylibrary", WORD);

run;

libname &mylibrary 'physical_path_to_library';

*-- end code --;

This assign every time a different random LIBREF to you library.

It works.

Regards

Paolo