Date: Tue, 2 Apr 1996 20:32:03 GMT
Reply-To: dstanle@ibm.net
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Don Stanley <dstanle@IBM.NET>
Organization: Information Power
Subject: Re: SAS Hint - How many Observations are there in a Member ?
however the fact remains that it is still quicker (by a long way
depending on how many sas libraries/members are defined in a session) to read
the
member header at compile using the set ... nobs method. The dictionary table
will require the whole dictionary table to be read looking for the one you
want,
while the compile time set method hones straight in to read just the header of
just
the desired member.
Don
In <01BB20F3.11DDA220@dp-m-b19.werple.net.au>, Alex Wolf <wolfam@WERPLE.NET.AU>
writes:
>In SAS 6.11 and possibly SAS 6.10 there is a SAS View in the SASHELP
>Libname this View contains Library, Member Name, Number of Observations
>and many other items that describe every member and instead of needing to
>use the Point, Noobs etc or a proc SQL to count the Observations You could use
> the
>following to count the number of Observations for my Member created in Work
>
>Data Frodo ;
>ring = 'gold' ;
>output ;
>run;
>
>data _null_ ;
>SET SASHELP.VTABLE ;
> IF MEMNAME = 'FRODO' THEN PUT 'The obs = ' NOBS ;
>RUN;
>
>the result: The obs = 1
>
>Cheers
>
>Alex M. Wolf.
==============================================================================
=
Don Stanley DSTANLE@IBM.NET
Information Power Limited
SAS Institute Quality Partners
Wellington NEW ZEALAND
Author : Beyond The Obvious With SAS Screen Control Language
Currently Writing : Effective Use Of The Frame Entry In SAS Software
(Working title)