- /*原始汇总的数据集Raw_data*/
-
- proc sql;
- create table Monthly_Falling_report as
- select stkcd,Trading_month1,
- Monthly_Falling_days/Monthly_trading_days as Monthly_freq_Falling label='每月下跌频率'
- from (
- select stkcd,put(Trading_month,yymms7.) as Trading_month1,
- count(*) as Monthly_trading_days label='月度交易天数',
- sum
- (case
- when price_range <0 then 1
- else 0
- end)
- as Monthly_Falling_days label='月度下跌天数'
- from (
- select stkcd,trddt,
- trddt as Trading_month format=yymms7. label='交易月份' ,
- (clsprc - opnprc)/opnprc as price_range label='每日涨跌幅度'
- from Raw_data ) as t
- group by stkcd,Trading_month1 )as t1
- ;
- quit;