Deleting a Column in a Data Set

The cstutildeletedscolumn macro deletes an existing column from a data set.
In this example, the macro deletes the comment2 column (which was created in the previous example) in the newstudy.source_values data set. The _cstMustBeEmpty parameter is set to N, which specifies that the macro should delete the column if values are present.
*********************
*  Delete a column  *
*********************;

%cstutildeletedscolumn(
        _cstStd=CDISC-SDTM,
        _cstStdVer=3.1.3,
        _cstDS=newstudy.source_values,
        _cstColumn=comment2,
        _cstMustBeEmpty=n,
        _cstTestMode=n);
Here are the modified columns in the newstudy.source_values data set. The comment2 column has been removed and the column count is reduced to 21:
modified columns in the newstudy.source_values data set
Here is the modified work._cstresults data set:
modified work._cstresults data set
Here is the updated transaction log data set:
updated transaction log data set