topic Re: Number of components in a library in SAS Procedures

Number of components in a library

ren2010 — Wed, 14 Apr 2010 15:51:22 GMT

Hi ,

I have a library that has, say for example 'n' number of sas datasets.Is there any way I can get the exact count of the sas data sets in the library.

Please help.

Ren

Re: Number of components in a library

Cynthia_sas — Wed, 14 Apr 2010 16:04:32 GMT

Hi:
There have been a LOT of previous forum postings on the use of DICTIONARY.TABLES or the "dictionary" information that is maintained by SAS. Another "view" of the dictionary files are the SASHELP.Vxxx files -- SASHELP.VCOLUMNS, SASHELP.VTABLES, etc.
There are also a lot of user group papers on these topics with very good examples about how to use the meta-information in these files to help you manage your libraries and write data-driven programs.
I recommend that you search the forum postings on the terms
dictionary.tables or sashelp tables

and you should find some useful hits.

cynthia

Re: Number of components in a library

ren2010 — Wed, 14 Apr 2010 16:50:11 GMT

I tried the following but NO ROWS SELECTED

proc sql;

select *
from dictionary.tables
where upcase(libname)='aa';
quit;

aa is my library where I have 'n' number of sas datasets.

Re: Number of components in a library

sbb — Wed, 14 Apr 2010 17:04:29 GMT

Check your WHERE clause - you UPCASE the variable but you specify a lower-case constant value..... Also, your code presumes you have a prior LIBNAME defined with a libref of "AA".

Scott Barry
SBBWorks, Inc.

Re: Number of components in a library

ren2010 — Wed, 14 Apr 2010 20:07:22 GMT

I tried the following,still did not work,says NO ROWS SELECTED

libname Aa 'O:\nnb_O\roms\quarter';
proc sql;

select *
from dictionary.tables
where libname='Aa';
quit;

Re: Number of components in a library

sbb — Wed, 14 Apr 2010 20:10:18 GMT

Suggest you desk-check the program by removing the WHERE.

Scott Barry
SBBWorks, Inc.

Re: Number of components in a library

Doc_Duke — Wed, 14 Apr 2010 20:49:07 GMT

LIBNAMES are stored internally to SAS as UPPER CASE. So Aa, aa, and AA are all the same library, AA. See the note in your log.