dear SAS-Experts, I have such a following dataset: data Beispiel2(label='Beispiel2'); input ID:8. Reason:$35. Code:5.; datalines; 20180101 AAA 25 20190101 AAA 25 20190101 BBB 12 20180102 AAA 25 20180105 CCC 84 20190105 BBB 12 20190105 AAA 25 20180101 CCC 84 20190102 BBB 12 20180105 AAA 25 20190102 AAA 25 20190101 CCC 84 ; run; proc sort data=Beispiel2; by id Reason; run; I want to get this final result: ID Reason_1 Code_1 Reason_2 Code_2 Reason_3 Code_3 20180101 AAA 25 CCC 84 20180102 AAA 25 20180105 AAA 25 CCC 84 20190101 AAA 25 BBB 12 CCC 84 20190102 AAA 25 BBB 12 20190105 AAA 25 BBB 12 rules: from the 1st dataset, for each ID, I copy each (code + reason) into 2 new variables Code_n and reason_n - if I have the same ID 2 times in the dataset, n=2, I have 2 blocks and create 2 sets of new variables - if I have the same ID 3 times in the dataset, n=3, I have 2 blocks and create 3 sets of new variables ... n max is 10. how should I proceed? thanks for your help regards PY
... View more