Your active data set will now contain the records or cases that you added from your second data set. Then, holding down the CTRL key, select your two SPSS will use the variable name from the active data set in the merged file. After we take this step, the dialog box appears as below. Select the Pair button to pair the two variables and move them to the “Variables in New Active Dataset” box. To do this, hold down the CTRL key and select your two variables in the “Unpaired Variables” box. In our example, the variables “Age” in the active data set and “SubjectAge” in the second data set both contain subjects’ age, so we want to pair them. If your have variables that are present in both files but have different names in the two files, you can pair them in your merged data set. Unpaired variables that are present in the active data set only are followed by “(*).” Unpaired variables that are present in the second data set only are followed by “(+).” If there are any variables that are present in one of your merge files but not in the other, these will appear in the “Unpaired Variables” box (highlighted blue in the screenshot above). The variables that are present in both merge files will be listed in the “Variables in New Active Dataset” window (highlighted yellow above). Note that, if you browsed to your second data set, DataSet2 (outlined in red below) will be replaced with your file path. The file pathway will then appear in the box under “An external SPSS Statistics data file.” Browse to the file that you want to merge with the active file and double-click on it. This brings up File Explorer on your computer. If the second file for your merge is not open in SPSS (as is the case in the screenshot below), select Browse. If the second file for your merge is open in SPSS, it will appear below “An open dataset” as illustrated below. This brings up an “Add Cases to” dialog box. To merge the two files select Data -> Merge Files -> Add Cases as illustrated below: We want to merge it with a second file containing the same information for another 40 students. The active data set in our example contains fictitious height, weight, and age data for 40 students. This first file is known as the active data set in SPSS. We start from the assumption that you have imported your files into SPSS (from Excel or MySQL, for example), and that you have your first file open. Click File -> Save As to save your merged file.If desired, pair unpaired variables for the merged data set by holding down the CTRL key, selecting the two variables, and clicking the Pair button.Select the second file for the merge if it is open in SPSS ORĬlick Browse and browse to the second file for your merge.Ensure that the first file you want to merge is open in SPSS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |