Workspace Node: Concatenate Variables - Specifications Tab

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

The Concatenate method of merging files simply adds the variables of the second file to those of the first. If there are more cases in either File 1 or File 2, the option selected in the Unmatched Cases group box will determine what Statistica will do. By default, Statistica will fill any extra cases with missing data.

Output

In this group box, select the variables to merge from the two data files.

File 1 Variables

    1. Click this button to display a variable selection dialog box containing variables from the first data file.
    1. Select the desired variables for the output file.

File 2 Variables

    1. Click this button to display a variable selection dialog box containing variables from the second data file.
    1. Select the desired variables to merge into the output file.

Unmatched Cases

Select an option to specify the manner of dealing with unmatched cases when the two files are merged.

Unmatched cases may result from unequal numbers of cases in the merged files, or because some of the cases do not meet the relational merge criteria.

Fill with MD

Select this option button to pad unmatched cases with missing data.

Delete

When this option button is selected, cases from either file that cannot be matched will be removed from the merged file.

Abort

When this option button is selected, the presence of unmatched cases in either file will cause an error message to be displayed and the merge procedure to be abandoned.

Options

See Common Options.

OK

Click the OK button to accept all the specifications made in the dialog box and to close it

To view the new spreadsheet, click the icon on the lower-right corner of the Concatenate Variables node.

See also, Home tab.