row id

[Cap2010]

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

 

[BNPMike]

Is this a SAS question?

Jet does not have row ids unless you add them like any other data item.

 

[Cap2010]

BNPMike,

It is through SQL to find out row id.

cap2010

 

[DanJR]

hi Cap2010,

Is there any particular reason why you want a row id? what problem are you trying to solve?

 

[PHV]

Select * from table1 where rowid > rowid+1
Are you sure this instruction returns something ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BNPMike]

Cap2010

SQL doesn't provide row numbers. Maybe some systems do (Oracle?). Jet doesn't. SQL doesn't require it to.