Production Ready Macros for SAS Application Developers
https://github.com/sasjs/core
mm_assigndirectlib.sas File Reference

Assigns library directly using details from metadata. More...

Go to the source code of this file.

Detailed Description

Queries metadata to get the libname definition then allocates the library directly (ie, not using the META engine). usage:

%mm_assignDirectLib(MyLib);
data x; set mylib.sometable; run;

%mm_assignDirectLib(MyDB,open_passthrough=MyAlias);
create table MyTable as
  select * from connection to MyAlias( select * from DBTable);
disconnect from MyAlias;
quit;

Dependencies

Parameters
librefthe libref (not name) of the metadata library
open_passthrough=provide an alias to produce the CONNECT TO statement for the relevant external database
sql_options=an override default output fileref to avoid naming clash
mDebug=set to 1 to show debug messages in the log
mAbort=set to 1 to call mp_abort().
Returns
libname statement
Version
9.2
Author
Allan Bowe

Definition in file mm_assigndirectlib.sas.