Hi, My post has lots of mistakes sorry for that 😅 To clarify what I want to do, I write example codes again. ( I want to attach the file I have but it is not possible for the server system that I'm using now) data have;
input date1 kind date2 date3 date4 code1 code2 num price;
cards;
201501 1 20000930 20210722 19600702 N 1 60 2000
201502 1 20000930 20210722 19600702 N 1 60 3000
201501 3 20011231 20211002 19990821 Y 2 61 3000
201507 5 20040308 99991231 19661230 Y 2 77 5000
201508 5 20040308 99991231 19661230 Y 2 77 5000
201512 1 20020125 99991231 19990821 Y 1 130 2000
;
run;
data want;
input date1 kind date2 date3 date4 code1 code2 num price tmp_no;
cards;
201501 1 20000930 20210722 19600702 N 1 60 2000 1
201502 1 20000930 20210722 19600702 N 1 60 3000 1
201501 3 20011231 20211002 19990821 Y 2 61 3000 2
201507 5 20040308 99991231 19661230 Y 2 77 5000 3
201508 5 20040308 99991231 19661230 Y 2 77 5000 3
201512 1 20020125 99991231 19990821 Y 1 130 2000 4
;
run; It seems your solution is setting the num1 as key value however it might be problem because I have 3,000 rows more and there could be same amount .. so I think it needs to be considered as it has 8 key values (kind date2 date3 date4 code1 code2 num), but I'm not sure if it's possible. Thank you for your reply!
... View more