ACMI'S POWERFUL KEYWORDS
- Five Keywords
- INCLUDE - Allows you to define or restrict the data elements in any data field included in the run. You may use any data field as an INCLUDE data field.
- EXCLUDE - The opposite of INCLUDE. It gives you the capability to specify the records of the database you wish to
EXCLUDE from a run. - CLASSIFY - A Powerful ACMI Function that breaks the data out by various levels of a data field and produces a line of output for each specified level. You may use any data field in the database as a CLASSIFY data field.
- DEPENDENT - A data field for which statistics (number, mean, total and standard deviation) are produced for each level of one or more CLASSIFY (independent) data fields.
- DRILLDOWN - Gives you the capability to get more information on records in a line of your report.
- INCLUDE or EXCLUDE Options
- USER - An INCLUDE/EXCLUDE option where you choose the data values for the data field at run time using any combination of single codes and ranges of codes.
- FILE - An INCLUDE/EXCLUDE option where data values are supplied from an external file. This option is often used for large lists of data values, e.g., patients' SSN, or for lists of data values used repeatedly.
- CLASSIFY Options
- ALL - Creates a line of output for every different value of the CLASSIFY data field.
- TOP - Creates a line of output for only the specified top (ranked) number of levels. ACMI sorts and ranks the result for each value of the CLASSIFY data field and reports only the TOP number of lines requested.
- USER - Allows you to set up codes or groups of codes with titles for CLASSIFY levels. User defines Titles and select codes from a list to insure valid codes.
- FILE - Allows you to use a pre-existing file of pre-defined Titles and values for the selected CLASSIFY data field.
- DEPENDENT Options
- Includes 0 and greater than: Include all selected records even if they have a '0' value in the DEPENDENT data field.
- Program includes values greater than the integer you enter: Include only records with values greater than an integer you specify. This option is most often used to eliminate records with '0' in the DEPENDENT data field, but you may specify any integer. DEPENDENT data fields are often days or money data fields.
- Select to Rank by: Applicable when you have a CLASSIFY that requires ranking your data (i.e., TOP x, where x is any integer) andyou select your first DEPENDENT data field. A screen appears with the option of ranking your output by number, mean, total or standard deviation.
- NUMBER - The count or frequency.
- MEAN - The TOTAL divided by the NUMBER (average).
- TOTAL - The sum.
- TOTAL_K - When TOTAL_K* appears instead of TOTAL, the original values are too large to print. Each value has been divided by 1000 and is presented in thousands (usually of dollars). Multiply each total value by 1000.
- S.D. (STANDARD DEVIATION) - Indicates the variability of the data. Large standard deviations indicate more variability.
- DRILLDOWN
- Allows you an unlimited number of drill downs to get more detailed information on records.
- Lets you print data values to the screen for any data fields you choose for any individual records you choose.