- 阅读权限
- 255
- 威望
- 0 级
- 论坛币
- 407 个
- 通用积分
- 9.2591
- 学术水平
- 43 点
- 热心指数
- 61 点
- 信用等级
- 33 点
- 经验
- 8153 点
- 帖子
- 294
- 精华
- 0
- 在线时间
- 436 小时
- 注册时间
- 2008-1-26
- 最后登录
- 2024-3-9
|
- proc sort data=Stock.Old out=Stock.New;
- by STOCKCODE STOCKNAME ITEM;
- run;
- proc transpose data=Stock.New out=Stock.New name=DATE;
- by STOCKCODE STOCKNAME ITEM;
- var _:;
- where STOCKCODE^='';
- run;
- proc sort data=Stock.New;
- by STOCKCODE STOCKNAME DATE;
- run;
- proc transpose data=Stock.New out=Stock.New;
- by STOCKCODE STOCKNAME DATE;
- var COL1;
- id ITEM;
- run;
- data Stock.New;
- retain STOCKCODE STOCKNAME DATE PRECLOSE OPEN HIGH LOW CLOSE CHANGE PCTCHANGE ISSTSTOCK;
- set Stock.New(drop=_NAME_);
- DATE=compress(DATE,,'dk');
- label DATE=;
- run;
复制代码
|
|