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.

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 that if you do not select any variables via 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.