I got some assistance from SAS Technical help and here is the code that worked for me. data metadata_libraries; length liburi upasnuri $256 name $128 type id $17 libref engine $8 path mdschemaname schema $256; keep name libref engine path mdschemaname schema; call missing(liburi,upasnuri,name,engine,libref); nlibobj=1; librc=metadata_getnobj("omsobj:SASLibrary?@Id contains '.'",nlibobj,liburi); do while (librc>0); rc=metadata_getattr(liburi,'Name',name); rc=metadata_getattr(liburi,'Engine',engine); rc=metadata_getattr(liburi,'Libref',libref); n=1; uprc=metadata_getnasn(liburi,'UsingPackages',n,upasnuri); if uprc > 0 then do; call missing(type,id,path,mdschemaname,schema); rc=metadata_resolve(upasnuri,type,id); if type='Directory' then do; rc=metadata_getattr(upasnuri,'DirectoryName',path); output; end; else if type='DatabaseSchema' then do; rc=metadata_getattr(upasnuri,'Name',mdschemaname); rc=metadata_getattr(upasnuri,'SchemaName',schema); output; end; n+1; uprc=metadata_getnasn(liburi,'UsingPackages',n,upasnuri); end; nlibobj+1; librc=metadata_getnobj("omsobj:SASLibrary?@Id contains '.'",nlibobj,liburi); end; run;
... View more