Supported Data Sources and Environments: Supported Data Sources and Environments

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. [cautionend]

Supported Data Sources and Platforms for the IMPORT and EXPORT Procedures, and the Import and Export Wizards
Data Source Description	Data Source Identifier	Import		Export		Supported Platforms	Supported SAS Platforms by Release
Data Source Description	Data Source Identifier	Wizard	PROC	Wizard	PROC	Supported Platforms	Supported SAS Platforms by Release
Excel using a LIBNAME engine	EXCEL EXCEL 97 EXCEL 2000 EXCEL 2002 EXCEL 2003 EXCEL 2007	Yes	Yes	Yes	Yes	32-bit Windows	SAS 9.0 or later
Excel using PC Files Server	EXCELCS	No Yes for Windows, starting in SAS 9.2 Phase 3 or later	Yes	No Yes for Windows, starting in SAS 9.2 Phase 3 or later	Yes	64-bit Windows Linux, UNIX	SAS 9.1.3 or later SAS 9.1 or later
Excel using .xls file formats	XLS	No	Yes	No	Yes	32-bit Windows 64-bit Windows Linux, UNIX	SAS 9.1.3 SP3 or later
Excel 4 using PROC ACCESS and PROC DBLOAD	EXCEL 4	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows	SAS 8.2 or later SAS 9.1.3 SP1 or later
Excel 5 using PROC ACCESS and PROC DBLOAD	EXCEL 5	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows	SAS 8.2 or later SAS 9.1.3 SP1 or later
Access 2000 using the LIBNAME engine	ACCESS ACCESS 2000 ACCESS 2002 ACCESS 2003 ACCESS 2007	Yes	Yes	Yes	Yes	32-bit Windows	SAS 9.0 or later
Access 97 using the LIBNAME engine	ACCESS 97	Yes	Yes	Yes	Yes	32-bit Windows	SAS 9.0 or later
Access using PC Files Server	ACCESSCS	No Yes for Windows, starting in SAS 9.2 Phase 3 or later	Yes	No Yes for Windows, starting in SAS 9.2 Phase 3 or later	Yes	64-bit Windows Linux, UNIX	SAS 9.1.3 or later SAS 9.1 or later
dBase using .DBF file formats	DBF	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows Linux, UNIX	SAS 8.2 or later SAS 9.1.3 SP1 or later SAS 8.1 or later
dBase file formats with MEMO support	DBFMEMO	No	Yes	No	Yes	32-bit Windows 64-bit Windows Linux, UNIX	SAS 9.2 or later
JMP using .JMP file formats	JMP	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows Linux, UNIX	SAS 9.1 or later SAS 9.1.3 or later SAS 9.1 or later
Paradox using .DB file formats	DB	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows Linux, UNIX	SAS 9.2 or later
SPSS using .SAV file formats	SAV	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows Linux, UNIX	SAS 9.1.3 SP3 or later
Stata using .DTA file formats	DTA	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows Linux, UNIX	SAS 9.1.3 SP3 or later
Lotus 1-2-3 using .WK1 file formats	WK1	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows	SAS 8.2 or later SAS 9.1.3 or later
Lotus 1-2-3 using .WK3 file formats	WK3	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows	SAS 8.2 or later SAS 9.1.3 or later
Lotus 1-2-3 using .WK4 file formats	WK4	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows	SAS 8.2 or later SAS 9.1.3 or later
Comma-separated file	CSV	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows Linux, UNIX Open VMS	SAS 8.2 or later
Tab-separated file	TAB	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows Linux, UNIX Open VMS	SAS 8.2 or later
Delimiter-separated file	DLM	Yes	Yes	Yes	Yes	32-bit Windows 64-bit Windows Linux, UNIX Open VMS	SAS 8.2 or later
Data files using client/server model	PCFS	No	Yes	No	Yes	64-bit Windows Linux, UNIX	SAS 9.1 or later

Note: This release on Windows 64-bit platforms, the Import Wizard, and the Export Wizard support access to Microsoft Access and Microsoft Excel files using PC Files Server. [cautionend]

Top of Page