Chapter Contents

Previous

Next
POINT

POINT



Locates a row that is identified by the NOTE function

Category: SAS Table


Syntax
Details
Example
See Also

Syntax

sysrc=POINT(table-id,note-id);

sysrc
contains the return code for the operation:
0 successful
[ne]0 not successful

Type: Numeric

table-id
is the identifier that was assigned when the table was opened. If table-id is invalid, the program halts.

Type: Numeric

note-id
is the identifier that was assigned to the row by the NOTE function, or -1 to go to the previous non-deleted row in the table. If note-id is invalid, the program halts and sends a message to the log.

Type: Numeric


Details

POINT locates the row identified by note-id, which is a value that is returned from NOTE. The Table Data Vector is not updated until a "read" is performed by FETCH or FETCHOBS.


Example

Call NOTE to obtain a row ID for the last row that was read in the SAS table MYDATA. Call POINT to point to the row that corresponds to note-id. Call FETCH to return the row that is marked by the pointer.

dsid=open('mydata','i');
rc=fetch(dsid);
noteid=note(dsid);
   ...more SCL statements...
rc=point(dsid,noteid);
rc=fetch(dsid);
   ...more SCL statements...
rc=close(dsid);

See Also

DROPNOTE

NOTE


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.