@AustinHarris wrote: I appreciate your help. I am a complete beginner to SAS with nearly no experience. This is my first piece of code, and I am learning as a go. I am certain I am doing things in the most inefficient manner possible... But I am doing them in ways that i know how and are somewhat working. My goal is of course to learn and take in information from individuals like yourself to become more efficient and knowledgeable in the SAS coding language/world.    I am going to attempt to implement this example and will let you know any results.    Thank you,  With your comment about "complete beginner" and "first piece of code" then my recommendation is NOT to attempt any macro language (the bits you have with &i are an example). A very minor macro logic issue can be very hard to trace down for a beginner because there can be a lot of timing and dependency issues that are not obvious to new users (and many fairly experienced).   I don't know if you have looked at your SAS online help at all but you may find bit titled "Learning to Use SAS" in the contents (depending on SAS environment). ... View more

@AustinHarris Short answer is: DON'T!  It's a bad idea to add total rows to data (tables). That's what you're doing in reports and many of the SAS procedures creating such reports allow for creation of totals (=collapsing categorial data). Same is true for any VA reporting. You want all your source data in your table to be on the same detail level as else any coding will become harder. ... View more