Decodes the formatted values of variables within a specified dataset.
%deformat(datname = dataset name,
outdat = output dataset,
fmtlib = format library);
Where | Is Type... | And represents... |
dataset name | C (optional) | Data set name for the source data. If this is left
blank, all datasets defined to the Trialex System will be decoded. |
outdat | C (optional) | Output dataset containing decoded values. If this is
left blank (recommended), the default dataset name will be the same name as the source
dataset followed by an underscore. For example: demog becomes demog_. |
fmtlib | C (optional) | The two level name of the format library. By default, the value is:
library.formats |
inlib | LIBNAME | Library referencing the location of the reports, programs and
data objects as defined to the Trialex System. | Details
This tool decodes the formatted values of any variable which contains a user
defined format. The formats are captured within the format catalog specified by the
format library parameters. A new dataset is created with additional variables
containing formatted values. The new formatted variables will have the variables
name followed by an underscore. For example, the variable ptid will become ptid_. If the new dataset names or formatted variable names exceed eight characters, the
names may be truncated. Note that numbers may also be appended to the end to
maintain uniqueness. Example libname inlib 'c:\myproject\mystudy';
%deformat;
%deformat(datname=demog);
%deformat(datname=demog, outdat=f_demog); |