PROC IMPORT syntax for importing Stata, SPSS, and JMP files


Starting in SAS 9.1.3 SP3, PROC IMPORT has the ability to import Stata, SPSS, and JMP files. SAS/ACCESS Interface to PC File Formats must be licensed and installed. The syntax is below:

  /* importing STATA files into SAS */

  proc import out=work.test1
  datafile='C:\stata_files\sfile1.dta'
  dbms=DTA replace;
  run;

  /* importing SPSS files into SAS */

  proc import out=work.test2
  datafile='C:\spss_files\sfile1.sav'
  dbms=SAV replace;
  run;

  /* importing JMP files into SAS */

  proc import out=work.test3
  datafile='C:\jmp_files\jfile1.jmp'
  dbms=JMP replace;
  run;