Thanks for your help, I think all the issues are solved. I needed to sort groups of data which I did by adding a new variable with a code to hold the rank of each group. I was able to produce the report finally. I am trying to absorb as much information about SAS as I can but would like to see an 'Examples' database to search on. I leaned heavily on the Internet but that is hit and miss.  ... View more

I am able to intercept the data before it gets summarized, so I think the problem is easiser, but still has issues. I need to have the States with the highest percentage in the latest date first, and have the three observations for each State listed in date sequence high to low. So even though Michigan and Nevada below have high percentages, they where not in the last observation. I hope I explained everything correct, since you've been a great help so far. datalines; "INDIANA","RED",01/01/2013,10 "INDIANA","RED",02/01/2013,10 "INDIANA","RED",03/01/2013,10 "OHIO","BLUE",01/01/2013,15 "OHIO","BLUE",02/01/2013,16 "OHIO","BLUE",03/01/2013,17 "MICHIGAN","GREEN",01/01/2013,18 "MICHIGAN","GREEN",02/01/2013,12 "MICHIGAN","GREEN",03/01/2013,13 "NEVADA","GREEN",01/01/2013,18 "NEVADA","GREEN",02/01/2013,10 "NEVADA","GREEN",03/01/2013,12 "CALIFORNIA","RED",01/01/2013,11 "CALIFORNIA","RED",02/01/2013,13 "CALIFORNIA","RED",03/01/2013,15 ; State    Status     Date       Percentage OHIO     BLUE     03/01/2013       17                   02/01/2013       16                   01/01/2013       15 CALIFORNIA RED   03/01/2013       15                   02/01/2013       13                   01/01/2013       11 MICHIGAN GREEN    03/01/2013       13                   02/01/2013       12                   01/01/2013       18 NEVADA   GREEN    03/01/2013       12                   02/01/2013       10                   01/01/2013       18 INDIANA   RED     03/01/2013       10                   02/01/2013       10                   01/01/2013       10 ... View more

The observatons are in the order that I want already. There are repeating groups in each observation that I am trying to print on seperate lines for each observation. There is also non-repeating information for each observation. I hope this helps as I am stuck trying to figure it out. datalines; "INDIANA","RED",01/01/2013,02/01/2013,03/01/2013,10,10,10 "OHIO","BLUE",01/01/2013,02/01/2013,03/01/2013,15,15,13 "MICHIGAN","GREEN",01/01/2013,02/01/2013,03/01/2013,12,12,11 "NEVADA","GREEN",01/01/2013,02/01/2013,03/01/2013,15,15,10 "CALIFORNIA","RED",01/01/2013,02/01/2013,03/01/2013,15,15,13 "ALASKA","RED",01/01/2013,02/01/2013,03/01/2013,15,15,13 ; State    Status     Date       Percentage INDIANA   RED     01/01/2013       10                   02/01/2013       10                   03/01/2013       10 OHIO     BLUE     01/01/2013       15                   02/01/2013       15                   03/01/2013       13 MICHIGAN GREEN    01/01/2013       12                   02/01/2013       12                   03/01/2013       11 NEVADA   GREEN    01/01/2013       15                   02/01/2013       15                   03/01/2013       10 ... View more