proc sql noprint;
/*企业数据要在6年到6年以上的*/
create table work.b as
select t.*,count(t.coname) as cnt
from work.a as t
group by t.coname
having cnt >= 6
order by t.coname,t.date;
/*企业数据不到6年的*/
create table work.c as
select t.* ,count(t.coname) as cnt
from work.a as t;
group by t.coname
having cnt < 6
order by t.coname,t.date;
quit;
/*中位数*/
proc means data = work.b noprint chartype qmethod=os nonobs median ;
var Dp cev net_cev sg;
output out=work.d median()=
/ autoname autolabel inherit;
run;
/*转置为了排序*/
proc transpose data = work.d out = work.e;
var Dp_median cev_median net_cev_median sg_median;
run;
quit;
/*排序*/
proc sql noprint;
create table work.f as
select _name_,col1
from work.e
order by col1;
quit;
扫码加好友，拉您进群
全部版块
我的主页
收藏
