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