The first example uses PROC IMPORT to import an SPSS system file (.sav). The second example uses PROC EXPORT to load the SPSS file from a SAS data set. These capabilities are in SAS 9.1.3 SP3 and require a license to SAS/ACCESS to PC File Formats.

To determine which products are licensed at your site, you can look in your SAS Log after submitting the following statements:

proc setinit noalias; 
run; 

Full syntax for the IMPORT and EXPORT procedures can be found in the SAS Online Documentation under SAS/ACCESS Interface to PC Files.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

/* EXAMPLE PROC IMPORT */
PROC IMPORT
  DATAFILE='c:\filename.sav'
  OUT=work.newfilename
  DBMS=SAV REPLACE;
RUN;

/* EXAMPLE PROC EXPORT */
PROC EXPORT DATA=sashelp.class 
   OUTFILE='c:\test'
   DBMS=SAV REPLACE;
RUN;
 

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Below, log snippets show expected SAS notes for respective procedures. You must have a valid SPSS .sav file to run the first example. Look for the formats in the WORK library. You must save them to a permanent location in order to use these formats in another SAS session.

6    PROC IMPORT
7      DATAFILE='C:\filename.sav'
8      OUT=work.newfilename
9      DBMS=SAV REPLACE;
NOTE: WORK.NEWFILENAME was successfully created.	
	

If we have formats assigned to the numeric variables, the file 'test.sav' will contain value labels.

12   PROC EXPORT DATA=sashelp.class
13      OUTFILE='c:\test'
14      DBMS=SAV REPLACE;
NOTE: "c:\test.sav" was successfully created.
	

Operating System and Release Information