proc sql;

create table nkwilling as

select

site
,mean(tbgrd) as m_tb

,mean(trgrd) as m_gr

from yourdata

group by 1

;

quit;

＊ODS导出怎么就不行？； data xxx; input province $ site $ tbgrd trgrd; datalines; hb cd 17.3 1.41 hb cd 17.62 0.45 jx dc 30.07 0.09 jx dc 58.85 0.19 ; ods _all_ close; proc means nway; ods output summary=zzz(keep=province site tbgrd_mean trgrd_mean rename=(tbgrd_mean=tbgrd trgrd_mean=trgrd)); class province site; var tbgrd trgrd; *ways 2; *types province*site; output out=yyy(drop=_type_ _freq_) mean=; ods listing; proc print data=yyy; proc print data=zzz; quit; ＊男人不能说不行，女人不能说不要。；