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 --