topic Re: Checking the engine use in a library in SAS Enterprise Guide

Checking the engine use in a library

alepage — Tue, 09 Feb 2021 22:51:46 GMT

Hello,

I have elaborate a simple macro to get the dataset list in a library as well as the number of observations.

However depending on the engine use into the base or spde, my macro need to be adapted.

For the first call, the library use base engine so I need to eliminate the spde wording from the macro, while the second

library use spde engine and the macro work perfectly.

Is there a way to check which engine is use in a library in other the make this macro more versatile.

Regards,

Alain

%MACRO nbobsindataset(path=);
libname SOURCE spde "&path.";

Proc sql;
create table want as
select libname,memname, nobs
from dictionary.tables
where libname='SOURCE'
;
QUIT;
%mend nbobsindataset;

/*%nbobsindataset(path=/.../data/bkp);*/
%nbobsindataset(path=/.../sas20206/wc/folder1);

Re: Checking the engine use in a library

Reeza — Tue, 09 Feb 2021 23:15:59 GMT

Have you checked the dictionary.libname table to see what metadata is stored on libraries? I would start there - I may have the name of the table wrong but there's a table in SASHELP that has the libraries and the metadata for said libraries.

Re: Checking the engine use in a library

ballardw — Tue, 09 Feb 2021 23:38:21 GMT

Close SASHELP.VLIBNAM

14   Proc sql;
15      describe table dictionary.libnames;
NOTE: SQL table DICTIONARY.LIBNAMES was created like:

create table DICTIONARY.LIBNAMES
  (
   libname char(8) label='Library Name',
   engine char(8) label='Engine Name',
   path char(1024) label='Pathname',
   level num label='Library Concatenation Level',
   fileformat char(8) label='Default File Format',
   readonly char(3) label='Read-only?',
   sequential char(3) label='Sequential?',
   sysdesc char(1024) label='System Information Description',
   sysname char(1024) label='System Information Name',
   sysvalue char(1024) label='System Information Value',
   temp char(3) label='Temp Access?'
  );

16   quit;