FMTSUM

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

CDISC Builder
FMTSUM

HTML report
of format summary

 

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.
The FMTSUM can be applied to many datasets within the specified source location data path at one time.
    CDISC Builder - CDISC Data Tools Software,  Meta-Xceed Inc.© 2009
Bookmark and Share