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

Username:
Password:

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.