topic Error with Macro library in SAS Programming

Error with Macro library

deleted_user — Fri, 19 Nov 2010 18:40:55 GMT

I am running a macro with following syntax for options,

Dm 'log;clear;output;clear;';
LIBNAME XYZZZ 'U:\0xxx Protocol\xxxx_Completedata_XYZZ';
LIBNAME LIBRARY 'C:\Users\rmalapati\Documents\My SAS Files\Sangamo_SB_509_0801\0801 Protocol\formats';
options linesize=200 pagesize=100;
libname macros 'U:\Macros';
options mprint mlogic mstored sasmstore=macros;
options linesize=256 pagesize=100;
ods listing;

The following error gets displayed after running the sas for second time, but when running on a new sas sesison with the same syntax the error cant be seen.

I know why the error is being displayed but am not able to get the right solution

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

How to get around this?

Re: Error with Macro library

SPR — Fri, 19 Nov 2010 19:17:43 GMT

Hello SAS_PHARM,

Simply move the line
[pre]
libname macros 'U:\Macros';
[/pre]
to the top and second (third, etc. ) time
submit a block of code not including this line.

Sincerely,
SPR

Re: Error with Macro library

Ksharp — Mon, 22 Nov 2010 03:09:05 GMT

Or . You need one more statement to release your libname.

[pre]
libname macros clear;
[/pre]

Ksharp

Re: Error with Macro library

PatrickG — Mon, 13 Dec 2010 14:19:16 GMT

This won't help you now, but when 9.3 comes out, it will have a
%SYSMSTORECLEAR statement that will close the current library and clear the libref.

Error with Macro library

pcavicch — Tue, 02 Aug 2011 11:38:14 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

Error with Macro library

Peter_C — Tue, 02 Aug 2011 12:12:25 GMT

without the data step code, you can assign a "random" libref like

libname A%scan( %sysfunc( ranuni(0), 9.7 ),2,.) 'physical path to library' ;

it creates a libref that is unlikely to repeat having a random 7 digit number following that A.

I just tested it and it even works within a %sysfunc( repeat( ,4 )) where it happily assigned 5 unique libnames (all with the same path)

%sysfunc( repeat( %nrstr(

libname A %%scan( %%sysfunc( ranuni(0), 9.7 ), 2, . ) 'my path' ;

), 4 ) ) ;

The reason the macros libname won't release is its use in option sasmstore=macros ;

I'm not sure you can release the sasmstore assignment. (nor sure I would want to release it)

Use Scott's approach - not performing the assignment of the macros libname after the first run. Place "one-time-only" code in the autoexec.

Peter