Date: Thu, 6 Apr 2000 20:23:39 GMT
Reply-To: pete2108@MY-DEJA.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: pete2108@MY-DEJA.COM
Organization: Deja.com - Before you buy.
Subject: Re: row number with Proc sql / DB2
by the way,
IBM claims to have made the latest DB2 ready for the web.
Just how web-enabled is a database, which cannot easily generate
webpage-contents ?
any views out there ?
-----------
In article <8cce4s$ipm$1@news.inet.tele.dk>,
"Lars Jacobsen" <laja@tdk.dk> wrote:
> Using the OUTOBS=x means that SAS will read every row in the DB table
> and only output x observations to the dataset (after sorting etc.)
> Instead use the INOBS= option witch functions like the OBS= dataset option
> ( SET ddd(OBS=x))
>
> This however does not solve your problem with reading data only from a
> certain
> rownumber.
>
> I'm not sure if it's usefull but POINT jumps to mind.
>
> --
> Kind Regards
> Lars Jacobsen
>
> "pete" <remarq2NOreSPAM@p.8m.com.invalid> wrote in message
> news:0c83291b.820be419@usw-ex0105-036.remarq.com...
> > Hi group,
> >
> > I need to extract a sekvential sample from a DB2-table (fetching
> > for instance records from record number 100 to 119, and nothing
> > else) to provide contents for a web-table .
> >
> > DB2 does not possess the concept of row numbers... this is a
> > well-known fact.
> >
> > At present, I do an outobs limit (upper limit of record number)
> > in my proc sql, and then a data step, subsetting with the _N_
> > value (lower limit of record number).
> > This work well when close to record 1, but when nearing end
> > observation, I need to fetch the whole table in to a dataset.
> >
> >
> > i.e... As we are using another extraction tool (SAS) we should be
> > able to cheat/enhance DB2... RIGHT ?
> >
> > any good ideas out there ?
> >
> >
> >
> > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
> *
> > The fastest and easiest way to search and participate in Usenet - Free!
> >
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
| 
