Required Arguments

DATA= INPUT DATA

specifies the input data. The input data can be retrieved from a SAS data set, an SQL view, a DATA step view, a SAS/ACCESS view descriptor, or and Microsoft Excel file

Default:the last SAS data set that was created.

Restriction:If the data set is permanent, specify its two-level name libref.SAS data-set.

DBMS= PC-FILE-FORMAT

specifies the PC file format that you want to access.

PC File Format Summary

File Type	Statement
DBF	DBMS = DBF
DIF	DBMS = DIF
EXCEL 97-2003	DBMS = EXCEL
WKn	DBMS = WK1
WKn	DBMS = WK3
WKn	DBMS = WK4
MDB	DBMS = MDB
XLS	DBMS = XLS