dc_getlibs.sas
Go to the documentation of this file.
1 /**
2  @file dc_getlibs.sas
3  @brief Gets all available libraries
4  @details There are two versions of this macro - a META and a VIYA version (in
5  different folders). The interfaces is the same. This version is VIYA.
6 
7  <h4> SAS Macros </h4>
8 
9  @version 9.3
10  @author 4GL Apps Ltd
11  @copyright 4GL Apps Ltd. This code may only be used within Data Controller
12  and may not be re-distributed or re-sold without the express permission of
13  4GL Apps Ltd.
14 **/
15 
16 %macro dc_getlibs(outds=mm_getlibs);
17 proc sql;
18 create table &outds as
19  select distinct libname as LibraryRef
20  ,libname as LibraryName length=256
21  ,engine
22  ,'' as libraryid length=17
23  from dictionary.libnames
24  where libname not in ('WORK','SASUSER');
25 insert into &syslast values ("&DC_LIBREF", "&DC_LIBNAME",'','V9');
26 
27 %mend dc_getlibs;