Simple Weighting: ASCII data

1. Enter a field to weight

Enter the record/column location in Field to weight (record/column:length format) and select the Enter key or choose Scan for Code Values.
You can only enter one record/column location.

2. Set the target percents for each code value

The following information about the selected field is displayed:

Sequence #

Displays the sequence # for the selected field.

Code Value(s)

Displays the Code Value(s) found in the data file for the selected field.

Value Label(s)

For ASCII data files, the Value Label displayed will be the same as the Code Value.

Observed Frequency

Displays the frequency for each code value of the selected field.

Observed Percent

Displays the percent of total for each code value of the selected field.

Target Percent

Enter the Target Percent for each Code Value or combined levels of Code Value(s).
The Total of all target percents must add to 100%.
There is a right-click context menu to allow Cut, Copy, Paste, Delete and Select All operations in the Target Percent column.

Resulting Weight

Displays the weight assigned based on the Target Percent entered.
When a variable is first selected, the Resulting Weight is calculated using the Target Percent that WinCross initially assigns to each code value. WinCross attempts to make an even distribution based on the number of code values for the selected field.

Clear Percents

Use Clear Percents to initialize Target Percent to 0.00 for all code values of the selected field. Using Clear Percents also initializes the Resulting Weight display for all code values.

Reset Percents

Use Reset Percents to reset Target Percent and Resulting Weight for all code values of the selected field to the WinCross defaults.

Combine Levels

Use Combine Levels to combine two or more Code Values into one. Highlight anywhere on the row for the code values you want to combine.

Dissolve Level

Dissolve Level allows you to dissolve a previously combined group of Code Values. Highlight anywhere on the row for the code values you want to dissolve.

Set Value Label

Highlight anywhere on the row for the desired code value and choose Set Value Label to edit the Value Label for the selected Code Value.
Enter the new Value Label text on the Value Label Text dialog.

3. Options

Field to write weight to

Use an existing field (record/column:width)
Enter the field (record/column:length format) in your data file where the weight will be written.
This field must be at least 5 columns in length and must not extend past the end of the data file.

Create a new field (width only)
Enter the width for a new field where the weight will be written.
This field must be at least 5 columns in length and will be added to the end of your data file.

Calculate to filtered sample size

Calculates the weights to the filtered sample size.
Filtered sample size is the total after applying the run filter.
The Filtered sample size will display below but cannot be modified.

Calculate to reduced sample size

Calculates the weights to the reduced sample size.
Reduced sample size is the total of all non-zero target percents.
The Reduced sample size will display below but cannot be modified.

Calculate to a custom sample size

Calculates the weights to the total entered in Custom sample size. When using Calculate to a custom sample size, only the weights are adjusted, the Data file sample size, Filtered sample size and Reduced sample size remain the same.

Use glossary transformations

Applies glossary statements written in the Setup Glossary Variables dialog prior to the calculation for simple weighting.

Run Filter

Enter Filter Logic to be applied to your simple weighting calculation.
You can select Write all cases to file to write all cases to the output data file; however, simple weighting will only be applied to those cases matching the filter criteria.
If you write all cases to the output data file you can check the box Fill cases that do not match filter with '1'. This allows you to assign a weight of 1.0 to those cases that do not meet the filter criteria but are still being written to the output data file.
Deselect the Run Filter is active option to remove the Run Filter from your simple weighting calculation.

Write Weights

Select Write Weights to write the weights to the open data file or a new data file.
Drive/Directory - Select the file path where you would like to save your new data file with the weights added.
File(s) - If you would like to save your file to a filename that currently exists and is displayed in the File(s) list, highlight the filename from the File(s) list.
Output file - Enter a name for your output data file or select an existing file from the File(s) list.
You can save to the open data file.
You will be prompted with a message explaining that the original data file will be backed up with a *.bak# extension added (with # = to a number, for example, example.dat.bak1 is the first backup file created for the original data file of example.dat).
The newly created data file will automatically reopen in WinCross.
You have the option of continuing by selecting Yes or cancelling the save by selecting No.
Save file as type - Select the file type for your output data file. The output data file must be the same type as the input data file.
Records per case - If you are using multi-record data, you must specify the number of Records per case in the original data file. Records that were added using the ADDREC option in the Glossary should not be included in this number.
Cases to write - Enter the number of cases to write to the output data file.
Select OK to run the simple weighting.
Saves the sample balancing specifications as jobname.swa to the folder where the open job file currently resides.
If jobname.swa already exists, it will automatically be replaced.

Save

Saves the simple weighting specifications as jobname.swa to the folder where the open job file currently resides.

Load

Use Load to open a simple weighting specifications file (*.swa) choosing a different folder/file path from where the open job file currently resides.

Save As

Allows you to save the simple weighting specifications to a file name (*.swa) and location of your choosing.

Cancel

Use Cancel to exit the Run Simple Weighting dialog. You will be prompted to save any changes made to the Run Simple Weighting dialog.

** This feature is not available in WinCross Runtime version.