楼主: lhm343
2884 11

sql稍微复杂语句无法运行 [推广有奖]

11
soporaeternus 发表于 2011-6-10 16:23:05
http://support.sas.com/kb/12/666.html
不知道会不会有用......还有关掉实时杀毒什么的试试看
Let them be hard, but never unjust

12
bobguy 发表于 2011-6-11 12:02:55
lhm343 发表于 2011-6-9 12:43
proc sql;
select  gender   from a;
quit;

上面的语句是可以成功运行的,但是下面的语句就无法运行了。

proc sql;
select distinct  gender   from a;
quit;

提示的错误信息为:

Error: Utility file open failed.


请教高手,为什么啊?
Your sas has problems.


14 data t1;
15
16 set sashelp.class;
17 do i=1 to 5e4;
18 output;
19 end;
20 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.T1 has 950000 observations and 6 variables.
NOTE: DATA statement used (Total process time):
real time 5.03 seconds
cpu time 0.26 seconds
 
21
22 proc sql;
23 select distinct sex
24 from t1
25 ;
26 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.31 seconds
cpu time 0.39 seconds

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群
GMT+8, 2026-1-2 19:36