march
请问我在sas里用菜单import一个excel表格。
运行下面的程序后，输出并没有average和total这两个变量。为什么？
libname study "f:\sasfiles\mydir";
data study.score;
Input ID test1 test2 test3 test4 test5;
average=mean(test1,test2,test3,test4,test5);
total=test1+test2+test3+test4+test5;
proc print data=study.score;
run;
下面是sas的log，
548 libname study "f:\sasfiles\mydir";
NOTE: Libref STUDY was successfully assigned as follows:
Engine: V8
Physical Name: f:\sasfiles\mydir
549
550 data study.score;
551 Input ID test1 test2 test3 test4 test5;
552 average=mean(test1,test2,test3,test4,test5);
553 total=test1+test2+test3+test4+test5;
ERROR: No CARDS or INFILE statement.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set STUDY.SCORE may be incomplete. When this step was stopped there were 0
observations and 8 variables.
WARNING: Data set STUDY.SCORE was not replaced because this step was stopped.
NOTE: DATA statement used:
real time 0.04 seconds
cpu time 0.01 seconds
554 proc print data=study.score;
555 run;
NOTE: There were 3 observations read from the data set STUDY.SCORE.
NOTE: PROCEDURE PRINT used:
real time 0.01 seconds
cpu time 0.01 seconds
cran
你的data step里没有infile，或者没有datalines阿。怎么读数据啊？
amitywei
libname study "f:\sasfiles\mydir"; /*建逻辑库
data study.score;
inflie ..........
Input ID test1 test2 test3 test4 test5;
average=mean(test1,test2,test3,test4,test5);
total=test1+test2+test3+test4+test5;
proc print data=study.score;
run;
或者
data study.score;
set..........
average=mean(test1,test2,test3,test4,test5);
total=test1+test2+test3+test4+test5;
proc print data=study.score;
run;
先看一下SAS基础编程的书吧。
yihui
ERROR: No CARDS or INFILE statement.
ourhomeqs
晕，你的数据在那输啊？
上面的哥哥已经给你回答了，呵呵。
cards
