Sample table scripts

The UNICOM Intelligence Developer Documentation Library comes with a number of sample mrScriptBasic (.mrs) files that demonstrate how to create tables using the UNICOM Intelligence Professional Tables Option. By default, these samples are installed into the [INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Scripts\Tables folder. You need to have the UNICOM Intelligence Professional Tables Option to run these samples. Some of the samples have additional requirements.

To	See	Sample script
Create a basic table	Creating a simple table of Age by Gender	MyFirstTable.mrs
Create a basic frequency table	Creating a frequency table and defining cell contents	MyFirstFrequencyTable.mrs
Create tables with more than one variable on an axis	Concatenation and nesting	ConcatenatingAndNesting.mrs MoreonConcatenatingAndNesting.mrs
Create a banner for use in multiple tables	Reusing axes	ReusingAxes.mrs
Create profile tables to display verbatims and non-aggregated respondent data.	Working with profile tables	ProfileTables.mrs

To:	See	Sample script
Change the contents of a table cell	Examples	CellContents.mrs
Change the information included in the base	Base element	BaseElements.mrs
Change the information included in the base using an expression	Special elements	SpecialElements.mrs
Change the categories included in the base	Element properties	IncludeInBase.mrs
Specify the elements to display for a variable	Element list syntax	ElementSpecifications.mrs
Add subtotals, totals and statistic values to a table, create net elements	Special elements	SpecialElements.mrs
Hide zero values or rows/columns	Handling zero values and setting hide rules Hiding rows and columns	ZeroValues.mrs HideRules.mrs
Show row percentages or column percentages depending on the orientation of a grid.	-	AllFieldsAndShowOpenEnds.mrs

To	See	Sample script
Create simple filters	Defining your first filter	MyFirstFilter.mrs
Create global, default and table document filters	More on filters	MoreOnFilters.mrs
Modify the base element by applying filters	Base element	BaseElements.mrs
Filter a series of tables on each category of a categorical variable	-	FilterOnAgeGroups.mrs
Filter hierarchical data	Filtering hierarchical data	HierarchicalFilters.mrs

To	See	Sample script
Add cell prefixes or suffixes	Displaying prefixes and suffixes for cell items	CellPrefixAndSuffixUsage.mrs
Change the labels for an element	Element list syntax	ElementSpecifications.mrs
Change the formatting for labels using HTML	HTML tables export: Formatted labels	FormattedLabels.mrs
Add images to labels	Displaying images for elements	DisplayElementImages.mrs
Change decimal places shown for an element	Specifying decimal places for summary statistic elements	DecimalPlacesOnSummaryElements.mrs
Sort the rows or columns of your tables	Introduction to sorting tables	MyFirstSortedTable.mrs
Sort complex tables	Sorting tables	SortedTables.mrs
Set up annotations for tables	Defining annotations	Annotations.mrs
Set up global table annotations	Defining global annotations	Annotations.mrs

To	See	Sample script
Create a table using numeric variables	Working with numeric variables	NumericVariables.mrs
Create bands from numeric variables	Special elements	SpecialElements.mrs
Show mean values of numeric variables	Special elements	SpecialElements.mrs
Create summary statistic tables for numeric variables by setting up standard axis expressions	Creating axis expressions in your script	AutoSummarizeNumerics.mrs
Save axis expressions to the metadata	Creating axis expressions in your script	AutoSummarizeNumericsAndSave.mrs
Create summary statistics table with statistics shown as elements	Creating summary statistic tables	SummaryStatisticTables.mrs
Automatically generate summary statistics (mean, standard deviation, etc.) for numeric variables	-	AllFieldsAndShowOpenEnds.mrs
Automatically categorize numeric variables, or generate summary statistics (mean, standard deviation, etc.) depending on the number of unique answers	-	AutoCategorizeWordTopLines.mrs

To	See	Sample script
Automatically categorize boolean variables into True and False categories	-	AllFieldsAndShowOpenEnds.mrs
	-	AutoCategorizeWordTopLines.mrs
Automatically categorize text variables into code values	-	Categorize.mrs
	-	CategorizeExample.dms

To	See	Sample script
Autocode text variables	Working with numeric variables	NumericVariables.mrs
Automatically categorize text answers to display one category for each unique answer	-	AutoCategorizeWordTopLines.mrs
Autocode text questions or place individual answers in an HTML file and link to it from the table annotations	-	AutoCategorizeWordTopLines.mrs
Embed the answers to text questions directly within your tables	-	AllFieldsAndShowOpenEnds.mrs

To	See	Sample script
Create simple grid tables	Creating a grid table	MyFirstGridTable.mrs
Tabulate data at different hierarchical levels, and set population levels	Understanding population levels	HierarchicalData.mrs
Set up tables for all categorical and grid questions at a specified level.	-	TabulateAllVariablesAtSpecifiedLevel.mrs
Create grid tables from a grid question or a numeric loop	Grid tables	GridTables.mrs
Create tables using slices from loops or grids	Grid and loop slices	GridAndLoopSlices.mrs
Combine two or more grid slices into a single category within the grid	Combining grid slices	CombineGridSlices.mrs
Loop through fields and create grid tables for numeric variables within the grid	-	AutoSummarizeNumericsAndSave.mrs
Data is collected as separate questions, instead of in a loop or grid, but the data is tabulated as if it is a grid	Derived grid tables	DerivedGridTables.mrs

To	See	Sample script
Work with weighted and unweighted bases	Base element	BaseElements.mrs
Create tables using a weighting variable	Weighting tables	WeightedTables.mrs
Create weighted tables using DMS scripting	See 7. Learning about weighting	DMSWeightedTables.mrs

To	See	Sample script
Apply a chi-square test	Example of the chi-square test	ChiSquareAndFisherTests.mrs
Apply a cell chi-square test	Example of the cell chi-square test	CellChiSquareTests.mrs
Apply a column proportions test	Examples of the column proportions test	ColumnProportionsTest.mrs
Apply a column means test	Examples of the column means test	QuanvertTables.mrs
Apply Fisher's exact test	Example of Fisher's exact test	ChiSquareAndFisherTests.mrs
Apply a net difference test	Example of the net difference test	NetDifferenceTest.mrs
Apply a paired preference test	Examples of the paired preference test	PairedPreferenceTest.mrs
Apply a product difference test	Example of the product difference test	ProductDifferenceTest.mrs
Apply a T-test test	Example of the T-test test	TTestTests.mrs
Apply a Tukey test	Example of the Tukey test	TukeyTest.mrs

To	See	Sample script
Export tables to HTML files	HTML tables export	HTMLExportOptions.mrs
Export charts to HTML files	Creating charts	HTMLCharts.mrs
Export to tables and charts to Microsoft Word	Microsoft Word tables export	WordExport.mrs
Export to Microsoft Word using a customized Word template	-	AutoCategorizeWordToplines.mrs
Export tables and charts to Microsoft Excel	Exporting to Microsoft Excel	ExcelExport.mrs
Format Excel sheets from .mrs files.	-	MSExcelFormatting.mrs
Export to Microsoft PowerPoint	Microsoft PowerPoint tables export	PowerPointExport.mrs
Export a table to a comma-separated text file	Text tables export	TextExport.mrs
Write the output from a table to a text file using the ADO recordset	Working with the ADO recordset	CellValues.mrs
Write the output from a table, including labels, to a text file using the ADO recordset	Working with the ADO recordset	CellValuesAndLabels.mrs

To	See	Sample script
Understand the structure of a table	Understanding axes	UnderstandingAxes.mrs
Work with versions of a metadata file	Working with versions	WorkingWithVersions.mrs RDBTables.mrs
Calculate percentages based on respondents who were asked a question in a version compared to the number who answered.	Changing the base to reflect the version	PercentageOnElementsAsked.mrs
Create topline tables for simple categorical variables in the UNICOM Intelligence Interviewer - Paper routing if they have a short name.	Working with labels	WorkingWithLabels.mrs
Create tables in different languages stored in the metadata	Working with languages	WorkingWithLanguages.mrs
Define a custom Japanese label.	Working with languages	JapaneseLabels.mrs

To	See	Sample script
Include functions that assist in modifying Table Object Model metadata.	Change Tracker: Functions	ChangeTrackerFunctions.mrs
Modify metadata and save the modifications to a table document file.	Change Tracker: Modifying metadata in a new table document	ChangeTrackerTest1_NewDocument.mrs
Open a table document that includes change tracker records, modify the metadata, and save the modifications to a table document file.	Change Tracker: Modifying metadata in an existing Table Document	ChangeTrackerTest2_OpenDocument.mrs

To	See	Sample script
Working with Quancept files	Loading other types of data	QuanceptTables.mrs
Working with Quantum files	Loading other types of data	QuantumTables.mrs
Working with Quanvert files, and working with a built-in base element	Loading other types of data	QuanvertTables.mrs
Working with data from an RDB database	Loading other types of data	RDBTables.mrs
Working with database questions.	Creating tables based on database questions	CreatingTablesBasedOnDatabaseQuestions .mrs
Working with .SAV files	Loading other types of data	SAVTables.mrs
Working with Surveycraft files	Loading other types of data	SurveyCraftTables.mrs