本来好好的程序, 今天突然报错了。。。【FALAG_1_NOTE】————————————————————————————————————————————
proc sql;
select case when horsepower>210 then 1 else 0 end as is_big, "big flag" as flag_note, count(*) as cttot
from sashelp.cars
group by 1,2;
quit;
也报错
————————————————————————————————————————————
proc sql;
create table hs300_ts_peek3a0 as
select var_ratio_flag2_&pctnote. as flag1, "var_ratio_flag2_&pctnote." as flag1_note, count(*) as cttot, sum(weight) as weight,
avg(ret_ahead) as ret_ahead_avg, std(ret_ahead) as ret_ahead_std, min(ret_ahead) as ret_ahead_min, max(ret_ahead) as ret_ahead_max,
avg(ret_after) as ret_after_avg, std(ret_after) as ret_after_std, min(ret_after) as ret_after_min, max(ret_after) as ret_after_max
from &ds.
group by 1,2;
quit;