- 阅读权限
- 255
- 威望
- 0 级
- 论坛币
- 873 个
- 通用积分
- 462.9982
- 学术水平
- 38 点
- 热心指数
- 43 点
- 信用等级
- 28 点
- 经验
- 4333 点
- 帖子
- 162
- 精华
- 0
- 在线时间
- 209 小时
- 注册时间
- 2014-7-14
- 最后登录
- 2024-4-24
|
- data a;
- input ID $ IND Group $ SubGroup $ ItemCount Price;
- cards;
- 00001 1 A A3 1 100000
- 00001 1 A A2 0 27000
- 00001 0 E E1 1 100
- 00001 0 B B2 1 2000
- 00001 0 B B3 0 2500
- 00001 0 C C3 1 1000
- 00001 0 D D4 1 200
- 00001 0 E E2 0 1000
- 00001 0 C C3 0 200
- 00001 0 D D2 0 400
- 00001 0 D D1 0 1000
- 00002 1 A A2 1 44400
- 00002 1 A A1 0 8940
- 00002 0 A A3 1 8800
- 00002 0 B B2 1 500
- 00002 0 C B3 0 1400
- 00002 0 C C3 1 110
- 00002 0 E E3 1 2500
- 00002 0 E E2 0 1200
- ;
- run;
- proc sort data=a;
- BY ID Group descending price;
- RUN;
- data tempa;
- set a;
- by ID ;
- if first.id;
- run;
- data finala;
- merge a (keep=ID Price) tempa(drop=price);
- by id;
- if first.id then ItemCount=1;else ItemCount=0;
- run;
- data b;
- input ID $ IND Group $ SubGroup $ ItemCount Price;
- cards;
- 00003 1 B B1 1 520
- 00003 0 B B2 0 440
- 00003 0 B B4 0 320
- 00003 0 B B3 0 190
- 00003 0 C C4 1 220
- 00003 0 E E3 1 100
- 00003 0 C C5 0 210
- 00003 0 D D2 1 420
- 00003 0 D D4 0 290
- 00004 1 B B2 1 700
- 00004 1 B B4 0 600
- 00004 0 C C3 1 240
- 00004 0 E E2 1 410
- 00004 0 D D1 1 260
- ;
- run;
- proc sort data=b;
- by ID Group SubGroup descending price;
- run;
- data tempb;
- set b;
- by ID ;
- if first.id;
- run;
- data finalb;
- merge b (keep=ID Price) tempb(drop=price);
- by id;
- if first.id then ItemCount=1;else ItemCount=0;
- run;
复制代码
|
|