Chapter Contents

Previous

Next
UPDATE

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


Chapter Contents

Previous

Next

Top of Page

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