Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

In SPSS, how do I concatenate files?

In SPSS, use the ADD FILES command to concatenate or append two or more data files. The files must be SPSS system files. To concatenate them simply, list the files to be merged using the /FILES subcommand. The concatenation follows the order of the files specified.

The first example adds three files called PART1.sav, PART2.sav, and PART3.sav in the c:\spssdata directory:

ADD FILES /FILE="C:\spssdata\PART1.sav" /FILE="C:\spssdata\PART2.sav" /FILE="C:\spssdata\PART3.sav". EXECUTE.

You can also index the files on a specific variable (such as case ID) if you wish; this is called interleaving files. The files are organized on the variable ID, so that the final saved data set is indexed according to this shared variable. Notice that the order of the files read into SPSS is reversed, but the final product is the same due to the /BY subcommand.

ADD FILES /FILE="C:\spssdata\PART3.sav" /FILE="C:\spssdata\PART2.sav" /FILE="C:\spssdata\PART1.sav" /BY=ID. EXECUTE.

For more about statistical and mathematical software, email the UITS Stat/Math Center, visit the center's web page, or phone 812-855-4724 (IUB) or 317-278-4740 (IUPUI). The center is located in Bloomington at 410 N. Park Avenue, and is open for consultation by appointment Monday-Friday 9am-5pm.

This is document aeqq in domain all.
Last modified on May 24, 2011.

Comments/Questions/Corrections

Use this form to offer suggestions, corrections, and additions to the Knowledge Base. We welcome your input!

If you are affiliated with Indiana University and would like assistance with a specific computing problem, please use the Ask a Consultant form, or contact your campus Support Center.

Contact Information

Note: We will reply to your comment at this address. If your message concerns a problem receiving email, please enter an alternate email address.