一些基本问题,如何在PROC SQL步骤中附加另一个变量的最小值?有比PROC SQL更好的方法吗?
Name Payment
Tom 30
Tom 45
Tom 15
Bill 20
Bill 100
我怎么能写一个PROC SQL语句,返回每个人的计数以及最小的"付款":
Name Number MinPayment
Tom 3 15
Bill 2 20
proc sql;
select Name
, count(Name) as Number
, min(Payment) as MinPayment
from have
group by Name
;
quit;