SAS Component Language Dictionary

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
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);