LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (April 1996, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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)


Back to: Top of message | Previous page | Main SAS-L page