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 1999, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 21 Apr 1999 14:08:33 -0700
Reply-To:     "William W. Viergever" <wwvierg@IBM.NET>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "William W. Viergever" <wwvierg@IBM.NET>
Subject:      Re[2]: The WHERE statement does not work for rawdata
In-Reply-To:  <>
Content-Type: text/plain; charset="us-ascii"

Does this mean that this thread is mow dead?

At 02:54 PM 4/21/99 -0400, GORRELP1 wrote: >The SAS Language Reference (p. 367) states: > >"The subsetting IF statement selects observations that have been read into the >program data vector. The WHERE statement selects observations before they are >brought into the program data vector. The subsetting IF is less efficient than >the WHERE statement because it must read each observation from the input data >set into the program data vector." > >Paul Gorrell > > >____________________Reply Separator____________________ >Subject: Re: The WHERE statement does not work for rawdata >Author: "Lambert; Bob" <Bob_Lambert@AFCC.COM> >Date: 04/21/1999 1:01 PM > >I believe the WHERE statement processes conditions BEFORE the PDV is loaded >and is therefore more efficient than the IF statement. I would appreciate >further clarification or debunkfication on this. > >Thanx, > >Bob Lambert >> -----Original Message----- >> From: Adolf Quast [SMTP:adolf-a.quast@DB.COM] >> Sent: Wednesday, April 21, 1999 7:25 AM >> Subject: Re: The WHERE statement does not work for rawdata >> >> Hi, >> >> the WHERE statement is very efficient because it uses the information >> stored in >> the PDV (program data vector) of a SAS-dataset. The PDV is created when a >> SAS-Dataset is built. The PDV contains information about field length and >> type. >> Your rawdata do not have a PDV, so they have to be read via INFILE and >> INPUT. >> >> Greetings >> Adolf Quast

---------------------------------------------------------------------------- William W. Viergever Voice : (916) 483-8398 Viergever & Associates Fax : (916) 486-1488 A SAS Institute Quality Partner (USA) E-mail : Sacramento, CA 95825 ----------------------------------------------------------------------------

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