SAS中文论坛

标题: excel import 到sas 的problem [打印本页]

作者: shiyiming 时间: 2009-2-2 00:01
标题: excel import 到sas 的problem
我是一名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 时间: 2009-2-3 05:30
标题: Re: excel import 到sas 的problem
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 时间: 2009-2-3 11:31
标题: Re: excel import 到sas 的problem
Thanks~

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)