摘要： In the following conditions:the select clause references a column that contains an aggregate function that is not listed in a group by clause.the select clause references a column that contains an aggregate function and other column or columns that are not listed in the group by clause.one or more c 阅读全文

摘要： 类似于sql标准语句，在proc sql 中可以对列进行统计，前提是要有group by 或having字句。avg mean count freq n css cv max min nmiss prt range std stderr sum sumwgt t uss var1 proc sql outobs=10;2 select distinct subporduct_code,mean(cmcc_fee,down_fee) as avgfee 3 from &dataset4 where calculated avgfee>10;5 quit;可以将计算生成的变... 阅读全文