BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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!
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
deleted_user
Not applicable
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;
SPR
Quartz | Level 8 SPR
Quartz | Level 8
Hello Weiz,

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

Sincerely,
SPR

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 4751 views
  • 0 likes
  • 3 in conversation