Professional > Data management scripting > Samples > Using the sample DMS files > Table scripting sample Data Management scripts
 
Table scripting sample Data Management scripts
To run these samples, you need to have UNICOM Intelligence Professional Tables Option installed. Some of the samples have additional requirements. For further information, see the notes about each sample below.
TablesDefineAxes.dms
This sample exports the Museum sample UNICOM Intelligence Data File to a new IBM SPSS Statistics.sav file and includes a Metadata section that sets up an axis expression for some of the numeric and text variables and an OnAfterJobEnd Event section that sets up tables for these and other variables in the output data source. For more information, see Creating axis expressions and exporting to IBM SPSS Statistics.
TablesDefineAxesExportToRDB.dms
This sample sets up some axis expressions in the Short Drinks sample metadata as follows: first, in the OnBeforeJobStart Event section, an axis expression that includes only summary special elements is set up for all numeric variables that don't already have one. Secondly, in the Metadata section, an axis expression is set up for a specific categorical variable. The variable is inside a grid variable and the axis expression sets up factors for the categories and inserts a mean element that is subsequently used to show an average in a grid table. The sample then exports the Short Drinks sample data to a new RDB database and includes an OnAfterJobEnd Event section that sets up batch tables. To run this sample, you need access to a SQL Server installation and appropriate user access rights. Before running the sample, you need to create a SQL Server database called TablesDefineAxesExportToRDB. For information on the axis expression for numeric variables, see Creating axis expressions in the OnBeforeJobStart Event section. For information on the axis expression for the categorical variable, see Creating special elements in metadata using a data management script.
TablesDefineSpecialElements.dms *
This sample creates derived variables including special elements and their associated helper elements. To run this sample, you need access to a SQL Server installation and appropriate user access rights. Before running the sample, you need to create a SQL Server database called TablesDefineSpecialElements. For more information, see Creating special elements in metadata using a data management script.
TablesFilteredBase.dms
This sample exports the Museum sample UNICOM Intelligence Data File to another UNICOM Intelligence Data File and has a Metadata section that demonstrates creating built-in base elements. For more information, see Creating built-in base elements.
TablesFirstScript.dms
This sample exports the Museum sample UNICOM Intelligence Data File to an RDB database and includes an OnAfterJobEnd Event section that scripts three tables, and then populates and exports them (along with a chart for each table) to HTML. To run this sample, you need to have access to a SQL Server installation and appropriate user access rights. Before running the sample, you need to create a SQL Server database called TablesFirstScript. By default, IBM SPSS Visualization is used for charting. The HTML Export component can optionally use the Microsoft Office Web Components (OWC), which is available from the Microsoft Download Center. For more information, see Creating tables using a data management script.
TablesLoopThroughPaperRouting.dms
This sample exports the Museum sample UNICOM Intelligence Data File to another UNICOM Intelligence Data File and includes an OnAfterJobEnd Event section that loops through the UNICOM Intelligence Interviewer - Paper routing items and creates a top-line table for all of the suitable simple questions in the routing that have a short name defined. After populating the tables, the tables are exported to HTML as charts. You need to have Microsoft Office 2007 or later installed to be able to export the charts.
TablesWeightingAllFieldsHdata.dms
This sample exports the Museum sample UNICOM Intelligence Data File to an RDB database, creates a weighting variable, uses the Weight component to set up weighting and creates a weighted table for each of the suitable variables in the output data source. To run this sample, you need to have access to a SQL Server installation and appropriate user access rights. Before running the sample, you need to create a SQL Server database called TablesWeightingAllFieldsHdata. For more information, see Exporting to RDB and creating multiple weighted tables.
This sample is designed to demonstrate how to set up and use weighting in your tables. It is not designed to show you how you should actually use weighting when analyzing survey results.
Requirements
UNICOM Intelligence Professional 7.5 Tables Option
Some scripts require the use of a SQL Server database
See also
Using the sample DMS files