Number of datasets in library

[rakeshvvv]

Dear All,

Can some one help me in writing number of dataset in a library into a macro variable.

For example:

If a library x has 50 datasets. I should get the value of 50 in macro variable.

Thanks

Rakesh

[CatCol]

Try this:

proc sql noprint;
select count(memname) into :number
from sashelp.vmember
where libname='CCARLIB' and memtype='DATA';
quit;

This example sets the macrovariable &number with the number of datasets in the CCARLIB library.

Regards,

[ballardw · Accepted solution]

Replace LIBRARY with the name of the library you want to use. The library names are kept in all capital letters in the table.

proc sql;
   select count(memname) into : dscount
   from dictionary.members
   where libname='LIBRARY' and memtype='DATA';
quit;

%put &dscount;

[Ron_MacroMaven]

for more information use this code

PROC sql noprint;
         create table list_memnames as
         select libname,
                monotonic() as memnum label='member number',
                memname, nobs,   nvar as nvars,   memlabel
         from   dictionary.tables
         where  libname eq "%upcase(&libname)"
           and  memtype eq 'DATA';
         quit;

Ron Fehd