全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 SAS专版
3076 5
2008-11-26

各位大侠 :

我是菜鸟菜菜鸟,刚开始学SAS。

从人大经济论坛down了SAS9.1

但是遇到一个问题,请各位大侠帮助!

有别人写的程序如下,运行良好:

PROC IMPORT OUT= FinancialSummary
            DATAFILE= "C:\PhDText_Examples\A1\FinancialSummary94_04.xls"
            DBMS=EXCEL2000 REPLACE;
     GETNAMES=YES;
  SHEET="FinancialSummary94_04";
RUN;
PROC Print data=FinancialSummary; run;
proc sort data=FinancialSummary out=temp; by descending roe; run;
proc print data=temp; run;
proc univariate data=FinancialSummary; var roe roa; run;

我基本就是抄袭了,写了程序如下,但是不能运行

proc import out=work.xing
             datafile="c:\xmq\460.xls"
    dbms=excel 2000 replace;
    getnames=yes;
run;
proc print data=work.xing;run;
proc sort data=work.xing out=temp;by descending roe;run;
proc print data=temp;run;
proc univarial data=temp;var roe roa;run;

运行日志如下:

1    proc import out=work.xing
2                 datafile="c:\xmq\460.xls"
3                 dbms=excel 2000 replace;
                             ---- -------
                             22   202
ERROR 22-322: Syntax error, expecting one of the following: ;, DATAFILE, DATATABLE, DBMS, FILE, OUT,
              REPLACE, TABLE.

ERROR 202-322: The option or parameter is not recognized and will be ignored.

4                 getnames=yes;
5    run;


6    proc print data=work.xing;run;
ERROR: File WORK.XING.DATA does not exist.

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds

7    proc sort data=work.xing out=temp;by descending roe;run;
ERROR: File WORK.XING.DATA does not exist.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TEMP may be incomplete.  When this step was stopped there were 0
         observations and 0 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

8    proc print data=temp;run;

NOTE: No variables in data set WORK.TEMP.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


9    proc univarial data=temp;var roe roa;run;
ERROR: Procedure UNIVARIAL not found.

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE UNIVARIAL used (Total process time):
      real time           0.03 seconds
      cpu time            0.00 seconds

实在不解,肯请高手指点一二!

不胜感激!

二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

全部回复
2008-11-26 22:18:00

proc import out=work.xing
             datafile="c:\xmq\460.xls"
    dbms=excel 2000 replace;
    getnames=yes;

sheet="460";
run;
proc print data=work.xing;run;
proc sort data=work.xing out=temp;by descending roe;run;
proc print data=temp;run;
proc univarial data=temp;var roe roa;run;


二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2008-11-26 22:27:00

dbms=excel2000,中间不要有空格,

然后如楼上所说的,你必须指明数据所在的表,sheet='sheet1$';

二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2008-11-26 23:56:00

两位大侠:

我按照你们提示的修改了一下,果然好了!

谢谢!

二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2008-11-27 16:59:00

正解  呵呵

二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2008-11-27 23:49:00
learning. thx.
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群