Supported Data Sources and Environments

The IMPORT and EXPORT procedures work within the limited range of available PC file formats if they reside locally on UNIX. The procedures work with a wider range of PC file formats if they reside locally on a PC.

The Import and Export Wizards and the IMPORT and EXPORT procedures are part of Base SAS software. If SAS/ACCESS Interface to PC files is not licensed, access is limited to JMP, CSV, TXT, and delimited files.

Alternate methods to access data are described in Methods for Accessing PC Files Data.

Note: The PC File Server version must match the SAS version.

Data Source & Environment Support Summary

Data Source		Import		Export		Supported Platforms
Description	Identifier	Wizard	PROC	Wizard	PROC	Supported Platforms
Excel using LIBNAME EXCEL engine	EXCEL¹ EXCEL97²	Yes	Yes	Yes	Yes	Microsoft Windows
Excel using PC Files Server	EXCELCS	Yes	Yes	Yes	Yes	Microsoft Windows, Linux, UNIX
Excel using .XLSX file formats	XLSX	No	Yes	No	Yes	Microsoft Windows, Linux, UNIX
Excel using .XLS file formats	XLS	No	Yes	No	Yes	Microsoft Windows, Linux, UNIX
Excel 4 using PROC ACCESS and PROC DBLOAD	EXCEL4	Yes	Yes	Yes	Yes	Microsoft Windows
Excel5 using PROC ACCESS and PROC DBLOAD	EXCEL5	Yes	Yes	Yes	Yes	Microsoft Windows
Access using LIBNAME ACCESS engine	ACCESS³ ACCESS2000⁴	Yes	Yes	Yes	Yes	Microsoft Windows
Access using PC Files Server	ACCESSCS	No⁵	Yes	No⁵	Yes	Microsoft Windows, Linux, UNIX
dBase using .DBF file formats	DBF	Yes	Yes	Yes	Yes	Microsoft Windows, Linux, UNIX
dBase file format with MEMO support	DBFMEMO	No	Yes	No	Yes	Microsoft Windows, Linux, UNIX
JMP using .JMP file formats	JMP	Yes	Yes	Yes	Yes	Microsoft Windows, Linux, UNIX
Paradox using .DB file formats	DB	Yes	Yes	Yes	Yes	Microsoft Windows, Linux, UNIX
SPSS using .SAV file formats	SAV	Yes	Yes	Yes	Yes	Microsoft Windows, Linux, UNIX
Stata using .DTA file formats	DTA	Yes	Yes	Yes	Yes	Microsoft Windows, Linux, UNIX
Lotus 1-2-3 using .WK1 file formats	WK1	Yes	Yes	Yes	Yes	Microsoft Windows
Lotus 1-2-3 using .WK3 file formats	WK3	Yes	Yes	Yes	Yes	Microsoft Windows
Lotus 1-2-3 using .WK4 file formats	WK4	Yes	Yes	Yes	Yes	Microsoft Windows
Comma-separated file	CSV	Yes	Yes	Yes	Yes	Microsoft Windows, Linux, UNIX, Open VMS
Tab-separated file	TAB	Yes	Yes	Yes	Yes	Microsoft Windows, Linux, UNIX, Open VMS
Delimiter-separated file	DLM	Yes	Yes	Yes	Yes	Microsoft Windows, Linux, UNIX, Open VMS
Data files using client/server model	PCFS	No	Yes	No	Yes	Microsoft Windows, Linux, UNIX
¹Data Source Identifier EXCEL has alias names EXCEL2007 and EXCEL2010. ²Data Source Identifier EXCEL97 has alias names EXCEL2000, EXCEL2002, and EXCEL2003. ³Data Source Identifier ACCESS has alias names ACCESS2007 and ACCESS2010. ⁴Data Source Identifier ACCESS2000 has alias names ACCESS2002 and ACCESS2003. ⁵Yes for Microsoft Windows, for SAS 9.2 Phase 3 up to and excluding this release.