This mrScriptBasic example shows how to set up target weighting in a variable, Weight, that must already exist. If you run the example when this variable does not exist, an error occurs. (For an example that creates this variable, see Creating a new variable to hold the weighting information.) The weighting is based on two variables, age and gender, and is based on equal proportions of respondents in each cell of the weighting matrix:

There are 16 cells in the weighting matrix. Here is the mrScriptBasic code to set up the weighting:

This example is in the UNICOM Intelligence Developer Documentation Library as a sample script called Weight3.mrs. For more information, see Sample mrScriptBasic files.

The variables that define the weighting matrix have been specified using an array variable and that the weighting targets have been specified as "16 * 5". This uses * (asterisk) as a convenient shorthand to indicate that all of the 16 cells in the weighting matrix have an identical target of 5.

Here is a table of age by gender run on the Museum example data weighted using the weight variable:

Now, suppose you want to specify different proportions for each cell in the table:

To specify this, replace the Wgt.CellRows.Targets = "16 * 5" line with the following:

Each CellRow object in the CellRows collection corresponds to one row in our weighting matrix. The order in which you specify the variables that are being used to define the weighting in the CreateWeight method, defines how the weighting matrix table is oriented. In this example, age was specified first and gender second, and so there are eight CellRow objects, each one corresponding to a category of the age variable. If you specified gender first and age second, there would be two CellRow objects: one for the Male category and one for the Female category of the gender variable.

Here is a table of age by gender run on the weighted data.

You might want to set the same target for most, but not all, of the cells in the weighting matrix. You can do this by first specifying the same target for all of the cells in the weighting matrix and then specifying the targets for any individual cells that differ. For example:

When you are setting up weighting in a DMS file, you can specify the cells in the matrix using the names of the categories. For example, you could specify the same weighting using the category names as follows:

You can also use this method when you run a standalone .mrs script in mrScript Command Line Runner using the /m: option to specify the .mdd file. This means that the MDM Document is created as an intrinsic variable (called MDM) in the script, so you would need to remove the line that creates the MDM object: Set MDM = CreateObject("MDM.Document").

If the main example, in which there is only one variable in the weighting matrix, in Simple target weighting example was in a DMS file, you specify it like this:

You can use a filter to exclude cases from the weighting process. When you do this, the value in the variable that is being used to record the weights (Weight in these examples) will be unchanged for any cases that do not pass the filter. You create the filter using the Weight.FilterExpression property. You can use any expression that is supported by the UNICOM Intelligence Data Model.

For example, the following two lines are equivalent and would exclude from the weighting calculation any cases in the 11-16 years category of the age variable.

The first line uses the ContainsAll function, which is part of the UNICOM Intelligence Function Library that comes with the UNICOM Intelligence Data Model. The second line uses the equivalent Arithmetic operators. For more information, see UNICOM Intelligence Function Library and Expression evaluation.

UNICOM Intelligence Professional