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 v9+ Windows (*.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 the Big Red II and Karst research computing systems, and the Windows Student Technology Center (STC) computers.

This is document agau in the Knowledge Base.
Last modified on 2017-05-25 16:59:27.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.