From sasCommunity
Jump to: navigation, search


Journeymen’s Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro Do Loops, Ronald J. Fehd


The SAS(R) macro language is simple, yet powerful. List Processing (dynamic programming) with Proc SQL is also simple, yet powerful. This paper provides a data review macro FreqAll which illustrates using Proc SQL reading Dictionary.Columns to replace macro %do loops.