Updating a Column in a Data Set

The cstutilupdatemetadatarecords macro updates column values. Specific records can be retrieved using the _cstDSIfClause parameter.

In this example, the record in newstudy.source_values that matches the _cstDSIfClause parameter (table='EG' and value='QTC') is modified. The LABEL column value (_cstColumn) is changed to

QT
                     Interval (QTc)

*********************
*  Update a record  *
*********************;

%cstutilupdatemetadatarecords(
        _cstStd=CDISC-SDTM,
        _cstStdVer=3.1.3,
        _cstDS=newstudy.source_values,
        _cstDSIfClause=table='EG' and value='QTC',
        _cstColumn=label,
        _cstValue=QT Interval (QTc),
        _cstTestMode=n);

Here is the value of the Column Description for QTC (PR Interval) before running the macro:

Here is the modified value of the Column Description for QTC (QT Interval (QTc)):

The results of the previous call to the cstutilupdatemetadatarecords macro are written to the work._cstresults data set in row 8. Here is the message that explains that this was an update of one record using the specified WHERE clause:

Here is the updated transaction log data set in row 4: