topic Number of datasets in library in SAS Programming

Number of datasets in library

rakeshvvv — Mon, 17 Jul 2017 19:37:49 GMT

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

Re: Number of datasets in library

CatCol — Mon, 17 Jul 2017 19:51:32 GMT

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,

Re: Number of datasets in library

ballardw — Mon, 17 Jul 2017 19:51:55 GMT

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;

Re: Number of datasets in library

Ron_MacroMaven — Tue, 18 Jul 2017 19:30:27 GMT

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