Workspace Node: Unstacking - Specifications Tab

The Unstacking workspace node can be accessed from the Feature Finder, ribbon bar, or Node Browser. Double-click the node to display the specifications dialog box.

.

Element Name Description
Variables Click this button to display a variable selection dialog box. Select the Code variable containing the unique variable IDs (for the unstacked file), Variables to unstack containing the variables that you want to unstack, and the Case ID variables (optional) containing the unique case or unit IDs (for the unstacked file).
When multiple rows with same key values are found From this drop-down menu, select a command to specify how to handle multiple references to the same case or unit IDs (rows) or variable IDs (columns). The following commands are available:
Generate an Error Select this command to stop the unstacking operation when multiple references to the same case (row) or variable (column) IDs are encountered; an error is issued when such cases are found.
Take the minimum value Select this command to use the minimum (smallest) value found for the respective multiple instances of case (row) or variable (column) IDs.
Take the maximum value Select this command to use the maximum (largest) value found for the respective multiple instances of case (row) or variable (column) IDs.
Take the first value Select this command to use the first value found for the respective multiple instances of case (row) or variable (column) IDs.
Take the last value Select this command to use the last value found for the respective multiple instances of case (row) or variable (column) IDs.
Take the mean value Select this command to compute the mean over the respective multiple instances of case (row) or variable (column) IDs.
Take the median value Select this command to compute the median over the respective multiple instances of case (row) or variable (column) IDs. [Note that you can use the Computation of percentiles option in the Options dialog box - Analyses/Graphs: Limits tab to customize the specific method to be used to compute the median value. For more information, see Percentile Calculation Options in Statistica.]
Count the number of valid obs Select this command to count the number of valid observations over the respective multiple instances of case (row) or variable (column) IDs.
Calculate the sum Select this command to calculate the sum over the respective multiple instances of case (row) or variable (column) IDs.
Calculate the std. dev. Select this command to calculate the standard deviation over the respective multiple instances of case (row) or variable (column) IDs.
Calculate the variance Select this command to calculate the variance over the respective multiple instances of case (row) or variable (column) IDs.
When multiple crosstab value variables are selected From this drop-down menu, select a command to customize the method to be used for aggregating the measurement or variable values. The following commands are available:
Place in separate variables Select this command to create multiple variables, one for each selected variable in the list of Value Variables.
Take the minimum value Select this command to use only the minimum (smallest) value found in the respective variables (only a single variable will be created for each unique combination of values or codes found in the Column Variables).
Take the maximum value Select this command to use only the maximum (largest) value found in the respective variables (only a single variable will be created for each unique combination of values or codes found in the Column Variables).
Take the mean value Select this command to use the mean over the values found in the respective variables (only a single variable will be created for each unique combination of values or codes found in the Column Variables).
Take the median value Select this command to use the median over the values found in the respective variables (only a single variable will be created for each unique combination of values or codes found in the Column Variables). (Note that you can use the Computation of percentiles option in the Options dialog box - Analyses/Graphs: Limits tab to customize the specific method to be used to compute the median value. For more information, see Percentile Calculation Options in Statistica.)
Evaluate a formula Select this command to type in a transformation formula (in the Formula field, see below) for combining the multiple values found in the respective variables (only a single variable will be created for each unique combination of values or codes found in the Column Variables). Use the spreadsheet formula syntax conventions and variable references to the positions and names of Value Variables as they appear in the input file (e.g., references to a variable V4 will resolve to the 4th variable or column in the input data file before the unstacking operation is applied).
Count the number of valid obs Select this command to count the number of valid observations over the values found in the respective variables (only a single variable will be created for each unique combination of values or codes found in the Column Variables).
Calculate the sum Select this command to calculate the sum over the values found in the respective variables (only a single variable will be created for each unique combination of values or codes found in the Column Variables).
Calculate the std. dev. Select this command to calculate the standard deviation over the values found in the respective variables (only a single variable will be created for each unique combination of values or codes found in the Column Variables).
Calculate the variance Select this command to calculate the variance over the values found in the respective variables (only a single variable will be created for each unique combination of values or codes found in the Column Variables).

Formula. When Evaluate a formula is selected in the When multiple crosstab value variables are selected drop-down menu (see above), type the formula in this field.

The input spreadsheet is sorted by case ID variables first, then code variables Select this check box if the input data file is already sorted into ascending order by the unique case, unit, or row IDs, and the selected variable, measurement, or column IDs. Data files that are already sorted in this manner can be processed much faster.
Include unselected variables in the generated output Select this check box to also use other variables (all variables that were not explicitly selected) and "carry them along" to the unstacked new data spreadsheet.
Make initial pass to determine number of variables in result spreadsheet Select this check box to specify that Statistica will determine how many variables will be in the resultant spreadsheet, as opposed to resizing the spreadsheet "on demand." It is recommended to select this option for the most optimal performance.
Treat missing data in code or case id variables as a valid value Select this check box to keep missing data (MD) in the output. Otherwise, MD is skipped when it is encountered during unstacking.
Preserve relative variable order in output Select this check box to keep variables in the output order they are seen in the data. Otherwise, the output is ordered first by the unselected variables and then by the unstack variables.
Sort output variables by code variable values When this check box is selected, the output variables will be sorted by the values found in the Code variable. When this check box is cleared, these variables are displayed in the order in which the Code variable values are seen in the file (which may be different if not all Code variable values are displayed for each Case ID value.)
Variable name separator Enter here one or more characters to be used when creating concatenated variable names for the unstacked file. For example, if two variables were selected for the column, variable, or measurement IDs, and you selected as the separator an ampersand ("&"), then the new variables would consist of the unique combinations of values found in the two variables, e.g., Avalue & BValue.
Maximum number of measure variables to create in result spreadsheet Enter the maximum number of variables that you want your row variables unstacked into.

Options. See Common Options.