Date:         Mon, 8 Dec 2008 14:56:57 -0500
Reply-To:     "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Subject:      Re: number of records of each dataset in a library
In-Reply-To:  <67f588aa0812080848p7a4d928ifc59063dfc9ba029@mail.gmail.com>
Content-Type: text/plain; charset=us-ascii

summary: SAShelp views: deprecated

The SAShelp views are the slowest method of obtaining this information.

my tests show the views taking 10 times as long as a read of an sql
dictionary.

As of v9 those views are from SQL Dictionary tables:

Proc SQL; describe view SASHELP.VTABLE;
          quit;

source: Dictionary.Tables

Ron Fehd  the sql vs contents maven  CDC Atlanta GA USA RJF2 at cdc dot
gov


> -----Original Message-----
> From: owner-sas-l@listserv.uga.edu
> [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of Akshaya Nathilvar
> Sent: Monday, December 08, 2008 11:48 AM
> To: Jeff
> Cc: SAS-L@listserv.uga.edu
> Subject: Re: number of records of each dataset in a library
>
> By querying SASHELP.VTABLE:
> Proc sql;
>     select memname 'Dataset Name',nobs '# of Records'
>         from sashelp.vtable
>             where libname=<lib> and memtype='DATA'; /*
> Libname should be in
> uppercase */
> Quit;
>
> Akshaya
>
>
> On Mon, Dec 8, 2008 at 11:30 AM, Jeff <zhujp98@gmail.com> wrote:
>
> > I want to list nuber of records of each dataset in a
> library, The resulting
> > table shoud look like:
> >
> >
> > datasetname #rOfrecords
> > ds1               2345
> > ds2                209
> > ---
> >
> > Thanks,
> > Jeff
> >
>
>