excel import 到sas 的problem

shiyiming

我是一名sas 的初學者, 在用excel import sas 方面遇到問題.
如下

59   PROC IMPORT DATAFILE = 'C:\Documents and Settings\Desktop\WARRANT
60   \warrant_200506.xls' OUT= China;
ERROR: Unable to determine datasource type.  Please use the DBMS= option


61   PROC PRINT DATA = China;
ERROR: File WORK.CHINA.DATA does not exist.
62   TITLE ' Warrant'
63   Run;
WARNING: The TITLE statement is ambiguous due to invalid options or unquoted text.

不知是什么問題?

謝謝

shiyiming

1) Please try the following:

dbms=EXCEL  if it is a Excel 2000 or 2002 spreadsheet .xls Microsoft Windows *
dbms=EXCEL4 if it is Excel 4.0 spreadsheet .xls Microsoft Windows
dbms=EXCEL5 if it is Excel 5.0 or 7.0 (95) spreadsheet .xls Microsoft Windows
dbms=EXCEL97 if it is Excel 97 or 7.0 (95) spreadsheet .xls Microsoft Windows *
dbms=EXCEL2000 if it is Excel 2000 spreadsheet .xls Microsoft Windows *

2) For the error about the title statement, please add a ";" after your title statement.
title '...';
run;

shiyiming

Thanks~