IBM Support

Merging Files with no key variable in SPSS

Troubleshooting


Problem

I've got data kept in two separate files, and I need to add one of the variables from one file to the other. Ordinarily I would use the Data->Merge Files->Add Variables routine, but my problem is that there is no unique Id variable in each file that I could use as the key variable to link the two files together. The files have exactly the same number of records, and I can sort them so that the records in each one appear in exactly the same order. In a spreadsheet application, such as Excel or Lotus 1-2-3, I would sort the files and then copy the proper column from one file and paste it into the other. How can I do this in SPSS?

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"19.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

19675

Document Information

Modified date:
16 April 2020

UID

swg21476705