SGF2007.028

From sasCommunity
Jump to: navigation, search

SGF2007.028:

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

Abstract:

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.

http://www2.sas.com/proceedings/forum2007/028-2007.pdf