一、目标:数据共有81行观测,需要统计出每组make下cou最大的值:
data test.a(keep=make drivetrain);
set sashelp.cars;
proc print data=a;
run;
proc sql;
create table test.b as
select * from
(select make,drivetrain,count(*) as cou from test.a group by make,drivetrain
一、目标:数据共有81行观测,需要统计出每组make下cou最大的值:
data test.a(keep=make drivetrain);
set sashelp.cars;
proc print data=a;
run;
proc sql;
create table test.b as
select * from
(select make,drivetrain,count(*) as cou from test.a group by make,drivetrain