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

The following display shows the value of the Column Description for QTC (PR Interval) before running the macro:

Before Running the Macro

The following display shows the modified value of the Column Description for QTC (QT Interval (QTc)):

Modified Value of the Column Description for QTC

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

Results of Running the Macro

The following display shows the updated transaction log data set in row 4:

Updated Transaction Log Data Set