Help using Base SAS procedures

PROC IMPORT Excel File to SAS 9.2

Reply
N/A
Posts: 0

PROC IMPORT Excel File to SAS 9.2

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!
Super Contributor
Super Contributor
Posts: 3,174

Re: PROC IMPORT Excel File to SAS 9.2

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: PROC IMPORT Excel File to SAS 9.2

Posted in reply to deleted_user
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;
Super Contributor
Super Contributor
Posts: 365

Re: PROC IMPORT Excel File to SAS 9.2

Posted in reply to deleted_user
Hello Weiz,

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

Sincerely,
SPR
Ask a Question
Discussion stats
  • 3 replies
  • 3487 views
  • 0 likes
  • 3 in conversation