I'm not sure how to go about doing what you just suggested. It seems like i would have to type out every results. The way i am getting my data is through a teradata server and it could be over a 100,000 results and i don't know how many prefix id's a policy might have. Knowing this information, would you still suggest using this method or should I focus on maybe creating a pivot? I'm really new to SAS (just started learning 2 weeks ago) and I am imagining a pivot similar to which i can create in excel. However, even an excel pivot can not get me all of the rows into a single cell. I'm used to using Hyperion and i was able to compute it using a simple formula: Sum(Policy_Prefx_ID, Policy_Number)
... View more