Merge Options - Text Labels Tab

Select the Text Labels tab in the Merge Options dialog box to access the options described here. Note that only the text labels of variables with the same name in both files will be merged. If two variables (from the two files) share the same name but you do not want to merge their text labels, then temporarily change the name of the variable in one of the files until the merge procedure is completed.
Option Description
Mode Select one of the options in the Mode group box to control how text labels are treated when you merge.
Replace text labels in File 1 with labels from File 2 Select this option button if you want to replace all the text labels in the File 1 data file with those from the File 2 data file.
For example, suppose you have two data sets you want to merge:
File 1   File 2  
Red 101 Yellow 101
Blue 102 Blue 102
Yellow 103 Green 103
Open the File 1 data file, select Merge from the Data menu to display the Merge Options dialog box, and select the File 2 data file. Then, if you choose to Replace text labels in File 1 with text labels from File 2, the result is:
Yellow 101
Blue 102
Green 103
Remove text labels from File 1 and replace with text labels from File 2

Select this option button if you want to remove the text label lists from File 1 and add all of the text labels from File 2.

For example, if you merge File 1 and File 2 in the previous example using the Remove text labels from File 1 and replace with text labels from File 2 option, the result is:
Yellow 101
Blue 102
Green 103
Keep text labels from File 1, but add to it those labels from File 2 Select this option button if you want to combine the text label lists from the File 2 data file with those of the File 1 data file. If any duplicated text labels are detected, Statistica uses the text labels from File 2.
For example, if you merge File 1 and File 2 in the previous example using the Keep text labels from File 1, but add to it those labels from File 2. option, the result is:
Red 101
Blue 102
Yellow 103
Select Click the Select button to choose only certain variables to merge. Note that the variables are paired together in the order that they appear in the respective spreadsheet and the names of the variables will be ignored.

For example, if you select variables 1-3 from File 1 and variables 2-4 from File 2, then the text labels of variable 1 from the File 1 will be merged with the text labels of variable 2 from File 2, etc.

Note: If you do not select any variables using the Select button, Statistica matches all variables that have the same name. For example, if File 1 contains a variable named Age, Statistica searches for a variable named Age in File 2 and merge the text labels of those two variables.