co_fund 发表于 2016-2-22 09:00 
-sysin前后加空格
-log 前后加空格
你好!我运行以下SAS文件。
/*********************************************************************/
PROC IMPORT OUT= WORK.a /*input excel*/
DATAFILE= "'F:\Project\xinjisas.xls"
DBMS=EXCEL REPLACE;
SHEET="Sheet1$";
GETNAMES=YES;
RUN;
data work.test;/*read all data*/
set work.a;
sum=0.1411*c1+0.0809*c2+0.0251*c3+0.1338*c4+0.1834*c5+0.1803*c6+0.0856*c7+0.213*c8+0.1437*c9+0.027*c10+0.1968*c11+0.1032*c12+0.0156*c13+0.0526*c14+0.213*c15+0.0545*c16+0.0326*c17+0.1032*c18+0.1334*c19+0.0867*c20+0.178*c21+0.231*c22+0.0326*c23+0.2739*c24+0.431*c25+0.462*c26+0.1756*c27+0.0862*c28+0.0576*c29+0.0969*c30+0.0352*c31+0.0234*c32+0.0211*c33+0.3311*c34+0.3311*c35+0.231*c36+0.0148*c37+0.0148*c38+0.1226*c39+0.0326*c40+0.0156*c41+0.0135*c42+0.0119*c43;
run;
proc sort data=test;by descending sum;/*sort all data*/
run;
data test;/*put all position percent*/
set test nobs=xx;
postion=_n_;
percent=_n_/xx*100;
run;
proc sort data=test;by postion;/*sort*/
run;
data test;/*rank*/
set test;
if percent<10 then rank='A';
else if percent<30 then rank='B';
else if percent<60 then rank='C';
else if percent<95 then rank='D';
else if percent<=100 then rank='E';
RUN;
PROC EXPORT DATA= WORK.test /*final out put all*/
OUTFILE= "F:\Project\AllSituationOutput.xls"
DBMS=EXCEL REPLACE;
SHEET="Sheet1";
RUN;
/**************************************************************/
出现了以下错误,请问是怎么回事啊,单独运行程序是出的来excel的,但是bat自动运行不出来
7
8
9
10 data work.test;/*read all data*/
11 set work.a;
WARNING: 截断的记录。
12 sum=0.1411*c1+0.0809*c2+0.0251*c3+0.1338*c4+0.1834*c5+0.1803*c6+0.0856*c7+0.213*c8+0.1437*c9+0.027*c10+0.1968*c11+0.
12 ! 1032*c12+0.0156*c13+0.0526*c14+0.213*c15+0.0545*c16+0.0326*c17+0.1032*c18+0.1334*c19+0.0867*c20+0.178*c21+0.231*c22+
12 ! 0.0326*c23+0.2739*c24+0.
13 run;
___
22
ERROR 22-322: 语法错误,期望下列之一: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX,
MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.
NOTE: 由于出错,SAS 系统停止处理该步。
NOTE: SAS 设置选项 OBS=0,并将继续检查语句。 这可能导致出现“NOTE: 数据集中没有观测”消息。
WARNING: 数据集 WORK.TEST 可能不完整。该步停止时,共有 0 个观测和 46 个变量。
NOTE: “DATA 语句”所用时间(总处理时间):
实际时间 0.01 秒
CPU 时间 0.01 秒