rowid ?

[captain]

hi,

Want to count rowid. One row by one row
and on each do a calculation and than go to next or previous row.

In oracle it is Rowid, wonder how to do in SAS for going by row.
e.g. in Oracle
Select * from table1 where rowid > rowid+1
Captain2010

[Mark D Powell]

ca**********@yahoo.com (captain) wrote in message news:<27**************************@posting.google. com>...

hi,

Want to count rowid. One row by one row
and on each do a calculation and than go to next or previous row.

In oracle it is Rowid, wonder how to do in SAS for going by row.
e.g. in Oracle
Select * from table1 where rowid > rowid+1
Captain2010

I think what you want is an explicit cursor written in pl/sql. See
the PL/SQL manaul.

declare
cursor c_example is select * from my_table;
begin
open c_example;
loop
fetch c_example into variable_list....
exit when c_example%notfound;
-- logic to do something here
end loop;
close c_example;
end;

Also look up Cursor For loops to have Oracle perform the open, fetch,
and close automatically rather than explicitly.

HTH -- Mark D Powell --

[Ed prochak]

ca**********@yahoo.com (captain) wrote in message news:<27**************************@posting.google. com>...

hi,

Want to count rowid. One row by one row
and on each do a calculation and than go to next or previous row.

In oracle it is Rowid, wonder how to do in SAS for going by row.
e.g. in Oracle
Select * from table1 where rowid > rowid+1
Captain2010

NOTE: comp.databases.oracle is obsolete. this topic is appropriate for
comp.databases.oracle.misc which I cross posted to with this reply.

Which do you want an answer for, ORACLE or SAS? These are two very
different systems.

If you want to count rows in an ORACLE system, use the SQL command:
SELECT COUNT(*) FROM table1 ;

HTH,
ed