Overview
Source data may use format catalogs to code some variables such as M
for Male or F for Female. In this case, it is helpful to have all of
this information identified before applying any transformation to CDISC.
The FMTSUM or format summary report will help you identify all the formats
and what their codes and decoded values are.
FMTSUM
Options
The FMTSUM screen allows you to select the data and associated format
catalog to generate your report. The data flow for this tool is shown here.
Source Data
and Format Catalog |
![](right_arrow.jpg) |
CDISC Builder
FMTSUM |
![](right_arrow.jpg) |
HTML report
of format summary |
|
![](fmtsum_gui.jpg)
The options available for
selecting data and options for FMTSUM are:
- Source Data - This is the
location of the dataset that is going to be used to generate the format
summary report.
- Preview - A preview of the
first 100 observations of the data that is selected.
- Search Criteria List - A list
of search criteria conditions used to find the related records.
- Format Path - The path to the
location of the format catalog associated with the selected source data.
- Output - The location and HTML
file that the report will be saved to.
- Base Code - The location of the
optional SAS base code that can be generated which generates the report
for FMTSUM.
- Save Code - The code saved in
this location will contain a macro call capturing all the options that
has been selected. This can therefore be executed independent from
this interface as a SAS program.
![](note.gif) |
The FMTSUM can
be applied to many datasets within the specified source location data
path at one time. |
|