Previous Page | Next Page

SAS Component Language Dictionary

UPDATE



Writes values from the Table Data Vector (TDV) to the current row in a SAS table
Category: SAS Table

Syntax
Details
Example
See Also

Syntax

sysrc=UPDATE(table-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


Details

The table must be opened in UPDATE mode. The row to be updated is the current row. To place values in the TDV, use PUTVARC, PUTVARN, or SET.


Example

Update the current row in the open SAS table whose table identifier value is stored in the column MYDATAID. If the return code, RC, is nonzero, the system error message is displayed on the message line.

rc=update(mydataid);
if rc then _msg_=sysmsg();


See Also

APPEND

FETCH

FETCHOBS

GETVARC and GETVARN

PUTVARC and PUTVARN

SET

Previous Page | Next Page | Top of Page