Number of components in a library

[ren2010]

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

[Cynthia_sas]

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

[ren2010]

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.

[sbb]

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.

[ren2010]

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;

[sbb]

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

Scott Barry
SBBWorks, Inc.

[Doc_Duke]

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.