Unstacking/Stacking - Unstacking Tab

Select the Unstacking tab of the Unstacking/Stacking dialog box to access options for the Unstacking operation, as, for example, illustrated in the Unstacking/Stacking dialog box topic or the Data - Unstacking/Stacking topic.
Option Description
Variables Click the Variables button to display a standard 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 Choose 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 Choose 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 Choose 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 Choose this command to use the first value found for the respective multiple instances of case (row) or variable (column) IDs.
Take the last value Choose this command to use the last value found for the respective multiple instances of case (row) or variable (column) IDs.
Take the mean value Choose this command to compute the mean over the respective multiple instances of case (row) or variable (column) IDs.
Take the median value Choose 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 Choose this command to count the number of valid observations over the respective multiple instances of case (row) or variable (column) IDs.
Calculate the sum Choose this command to calculate the sum over the respective multiple instances of case (row) or variable (column) IDs.
Calculate the standard deviation Choose this command to calculate the standard deviation over the respective multiple instances of case (row) or variable (column) IDs.
Calculate the variance Choose this command to calculate the variance over the respective multiple instances of case (row) or variable (column) IDs.
When multiple cross tab 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 (see also the Unstacking/Stacking dialog box topic or the Data - Stacking/Unstacking topic). The following commands are available.
Place in separate variables Choose this command to create multiple variables, one for each selected variable in the list of Value Variables.
Take the minimum value Choose 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 Choose 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 Choose 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 Use 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 Use this command to type in a transformation formula 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 Choose 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 Choose 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 standard deviation Choose 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 Choose 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).
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.