It may help to print 10 or so lines to show the actual structure of the dataset. Your comment about "adding to %100" makes me think that the example data you showed is not what you are starting with. Describe what you start with and the desired result.
... View more
And, for the extra 10 points, here's a paper I wrote about Macro Basics for New SAS Users: https://support.sas.com/resources/papers/proceedings13/120-2013.pdf It may help you get started. cynthia
... View more
Hi, FYI I got my answer having posted in ODS as suggested.. For those interested. https://communities.sas.com/thread/86504 Thanks for taking the time to help me out.
... View more