topic Re: PROC IMPORT Excel File to SAS 9.2 in SAS Procedures

PROC IMPORT Excel File to SAS 9.2

deleted_user — Sat, 30 Oct 2010 12:53:44 GMT

Hello,

I am new to SAS 9.2 and trying to import an excel 2003 data to SAS by using following code.

PROC IMPORT out= ds_api
datafile= "C:\RawData - 201001.xls"
dbms = excel2000 replace;
range="API PACS$";
getnames=yes;
RUN;

However I got error message

ERROR: DBMS type EXCEL2000 not valid for import

Does anyone know the reason and how to fix it? Thanks!

Re: PROC IMPORT Excel File to SAS 9.2

sbb — Sat, 30 Oct 2010 15:04:36 GMT

Suggest searching the SAS support http://support.sas.com/ website - here is a SAS usage note that may apply:

Usage Note 33228: An error occurs when you use SAS® 9.2 to import or export Microsoft Excel or Access files in the Windows x64 and Windows Vista 64 environments

http://support.sas.com/kb/33/228.html

Some additional DOC reference at the SAS Support website, as well:

http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103761.htm

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic / post:

sas 9.2 proc import dbms excel2000 site:sas.com

Re: PROC IMPORT Excel File to SAS 9.2

deleted_user — Mon, 13 Dec 2010 07:20:05 GMT

Hello,

I am not sure but ...
What about this for your program.

PROC IMPORT OUT= ds_api
DATAFILE= 'C:\RawData - 201001.xls
DBMS=EXCEL REPLACE;
RANGE="API PACS$";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;

Re: PROC IMPORT Excel File to SAS 9.2

SPR — Mon, 13 Dec 2010 18:34:20 GMT

Hello Weiz,

Try
[pre]
dbms=XLS replace;
[/pre]

Sincerely,
SPR