- 阅读权限
- 255
- 威望
- 0 级
- 论坛币
- 11639 个
- 通用积分
- 100.1677
- 学术水平
- 13 点
- 热心指数
- 17 点
- 信用等级
- 17 点
- 经验
- 4593 点
- 帖子
- 85
- 精华
- 0
- 在线时间
- 290 小时
- 注册时间
- 2006-2-21
- 最后登录
- 2021-10-24
|
不难: - data raw;
- input date s_name $ net;
- informat date yymmdd10. s_name $10. net best10.;
- format date yymmdd10.;
- cards;
- 2020/1/1 ABC 1.1
- 2020/1/2 ABC 1.2
- 2020/1/3 ABC 1.3
- 2020/1/4 ABC 1.4
- 2020/1/5 ABC 1.8
- 2020/1/6 ABC 1.6
- 2020/1/7 ABC 1.7
- 2020/1/8 ABC 1.8
- 2020/1/9 ABC 1.9
- 2020/1/10 ABC 2
- 2020/1/11 ABC 2.1
- 2020/1/12 ABC 2.2
- 2020/1/1 孙悟空 1.1
- 2020/1/2 孙悟空 1.2
- 2020/1/3 孙悟空 1.3
- 2020/1/4 孙悟空 1.9
- 2020/1/5 孙悟空 1.5
- 2020/1/6 孙悟空 1.6
- 2020/1/7 孙悟空 1.7
- 2020/1/8 孙悟空 1.8
- 2020/1/1 3 1.1
- 2020/1/2 3 1.2
- 2020/1/3 3 1.3
- 2020/1/4 3 1.4
- 2020/1/5 3 2.1
- 2020/1/6 3 1.6
- 2020/1/7 3 1.7
- 2020/1/8 3 1.8
- 2020/1/9 3 1.9
- 2020/1/10 3 2.0
- 2020/1/11 3 2.1
- 2020/1/12 3 2.2
- ;run;
- proc sort data = raw;
- by s_name date;
- run;
- data max_recall;
- retain date s_name net max_net DrawDown max_DD;
- set raw;
- by s_name;
- retain max_net max_DD 0;
- if first.s_name then do;
- max_net=0; max_DD=0;
- end;
- if net > max_net then max_net = net;
- DrawDown = net - max_net;
- if DrawDown < max_DD then max_DD = DrawDown;
- run;
- proc sql;
- create table max_recall_summ as
- select distinct s_name
- ,min(max_DD) as max_DD
- from max_recall
- group by 1
- ;quit;
复制代码
|
-
总评分: 论坛币 + 50
查看全部评分
|