6.3 Signature File Output
This file contains metadata associated with production of the report. The name of the file is signature_[reportid] where [reportid] takes the value specified for reportid in the report_parameters file.
| Variable | Description |
|---|---|
| QRPREPORTVERSION | Version of QRP Report used. |
| Format: SAS character - length can vary | |
| CUSTOMCODEVERSION | Version assigned to the custom programming package. |
| Format: SAS character - length can vary | |
| STARTTIME | Date and time the program started in the format DDMMMYYYY:HH:MM:SS.SS. |
| Format: SAS character $21 | |
| STOPTIME | Date and time the program completed in the format DDMMMYYYY:HH:MM:SS.SS. |
| Format: SAS character $21 | |
| SECONDS | Total run time for the program in seconds. |
| Format: SAS character $9 | |
| EXECUTIONTIME | Total run time for the program in the format ##h ##m ##s. |
| Format: SAS character $25 | |
| REPORTID | Report identifier. |
| Format: SAS character - length can vary | |
| REPORTTYPE | Identifier of which type of report was produced. |
| Format: SAS character $10 | |
| REPORTDATA | Indicator of whether SAS datasets were produced (Y) or not (N). |
| Format: SAS character $10 | |
| LOOK_START | Period at which the report began. |
| Format: Numeric | |
| LOOK_END | Period at which the report ended. |
| Format: Numeric | |
| DATEDISTRIBUTED | Date the query request package was distributed to Data Partners. |
| Format: SAS character $10 | |
| REPORT_DESTINATION | Indicator of whether report was output as pdf, excel, or both. |
| Format: SAS character $5 | |
| LOGOFILE | File name for logo displayed in report |
| Format: SAS character $32 | |
| DATABASE | Name of database. If blank, will default to “Sentinel Distributed Database.” |
| Format: SAS character - length can vary | |
| DPNAME | Full name of data partner. Will be blank when QRP Report is run as a standalone. |
| Format: SAS character - length can vary | |
| STRATIFYBYDP | Indicator of whether Data Partner-specific results were produced. |
| Format: SAS character $1 | |
| DPINFOFILE | Name of the dataset listing Data Partners included in the report. |
| Note 1: only relevant for leave behind report. | |
| Format: SAS character $32 | |
| BASELINEFILE | Name of the dataset containing options for baseline tables. |
| Format: SAS character $32 | |
| GROUPSFILE | Name of the dataset containing lists of groups and parameters related to each group for L1 reports. |
| Format: SAS character $32 | |
| TABLEFILE | Name of the dataset containing all tables produced. |
| Format: SAS character $32 | |
| FIGUREFILE | Name of the dataset containing all figures produced. |
| Format: SAS character $32 | |
| LABELFILE | Name of the dataset containing all labels used in the report. |
| Format: SAS character $32 | |
| TREEAGGFILE | Name of the dataset containing tree aggregation parameters for Signal Identification analysis. |
| Format: SAS character $32 | |
| APPENDIXFILE | Name of the dataset containing information to be included in report appendices. |
| Format: SAS character $32 | |
| CODEDESCRIPTIONSFILE | Name of the dataset used to map code description for Code Distribution output. |
| Format: SAS character $32 | |
| TABLECOLUMNSFILE | Name of the dataset containing information about columns to output in report tables. |
| Format: SAS character $32 | |
| L2COMPARISONFILE | Name of the dataset containing lists of comparisons and parameters related to each comparison for L2 reports. |
| Format: SAS character $32 | |
| COLLAPSE_VARS | List of categories (if any) collapsed into one category to prevent small cell counts. |
| Format: SAS character $4 | |
| INCLUDE_UNWEIGHTED_TRIM | Indicator of whether unweighted/trimmed output is included in the report |
| Format: SAS character $1 | |
| SMALL_CELLCOUNTS | Indicator of whether small cells are highlighted in the output. |
| Format: SAS character $1 | |
| CUSTOMIZECOLUMNS | Indicator of which columns were displayed or redacted. Only relevant for T2L2 or T4L2 report. |
| Format: SAS character - length can vary | |
| SEED | Numeric value used as seed value for randomizing Data Partner IDs. |
| Format: Numeric |