Needing some help with converting a data set with multiple rows for the same data set to multiple columns. An example of the current data set is: ID Number Type 1 A 1 AA 2 A 2 AAA 2 AAAAAAA 3 AAAAAAAAAA 4 AA 4 A 5 A 5 AAAAAAA 5 AAAA An example of what the data set needs to look like is: ID Number Type Type 2 Type 3 Type 4 Type 5 1 A AA 2 A AAA AAAAAAA AAAAAAAAAA 3 AAAAAAAAAA 4 AA A 5 A AAAAAAA AAAA I have tried a proc transpose however that has resulted in an output like this: ID Number Type A Type 2 Type 3 Type 4 Type 5 Type 6 Type 7 Type 8 Type 9 1 1 2 1 1 1 1 3 1 4 1 1 5 1 1 1 Thank you for your help
... View more