I have account number and the ratings for the previous months and the current month like below Account Number  Aug Rating                Account Number          Sept Rating 100                             A                       100                                   A 200                             D                        123                                  F      300                             C                        400                                  B 400                             A                         500                                 C 500                             D                         300                                 C --                                - --                                -    I need the ouput in sas in such way that i need to know whether the how the ratings are moving compared to that previous month. I was able to get in this kind of excel , but need to write in SAS. Any help is highly appreciated.                                   Sept Rating Aug Rating                      A               B              C   D  E F A                                   1                1 B C                                                                     1 D                                                                     1 E Thanks Raj ... View more