SAS Script To Transpose Hierarchy Dataset

[jjb373]

Please review the below layout for current state and desired state of the data. I am trying to come up with a SAS Script to run to address the need of transposing(creating a cross-tab) a hierarchy dataset.


RAW DATA
IDNumber Group LetterRating
123 Finance A
123 Sales B
123 Ops A
456 Finance C
456 Ops A
789 Finance A
789 Ops B
789 Ops C
789 Ops C
000 Sales B
000 Finance A




DESIRED FORMAT
IDNumber Rating A Rating B Rating C
123 Finance/Ops Sales
456 Ops Finance
789 Finance Ops Ops
000 Finance Sales


-- JJB373 --

 

[beccy123]

Hey,

Have a look at my reply to a different query raised - you want to do something similar to this:

http://www.tek-tips.com/viewthread.cfm?qid=1629289&page=1