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

How can I convert an SPSS file to a SAS data set?

You have at least three options for converting data from SPSS format into SAS format. From SAS, you can read SPSS files directly through the IMPORT procedure. You can also use SPSS to save data in SAS format. Finally, programs such as Stat/Transfer can convert files from one package to another.

The PROC IMPORT procedure

The following SAS program will read an SPSS file saved in the C: directory and store it as a temporary file in the SAS WORK library:

PROC IMPORT DATAFILE='c:\filename.sav' OUT=work.newfilename DBMS=SAV replace; RUN;

To save the data as a SAS permanent file, replace work in the OUT= option with the name of a previously defined library.

The SPSS graphical interface

Open your data in SPSS. To create a SAS file, click File, and then Save As... . Change "Save as type" to SAS v7+ Windows long extension (*.sas7bdat), and then click Save.

Stat/Transfer

You can use Stat/Transfer to convert files between SAS and SPSS. At Indiana University, the Stat/Transfer software is available on Quarry and the Windows Student Technology Center (STC) computers.

For more information 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 agau in domain all.
Last modified on November 02, 2009.

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.