How To Use Proc SQL select into for List Processing

From sasCommunity

[edit] How To Use Proc SQL select into for List Processing

Ronald J. Fehd

Abstract

The SAS(R) macro language is simple, yet powerful. List Processing with Proc SQL is also simple, yet powerful. This Hands On Workshop paper provides programmers with knowledge to use the Proc SQL select into clause with the various SQL dictionaries to replace macro arrays and %do loops.

Audience: intermediate to advanced users, and macro programmers.

Keywords: dynamic programming, list processing, macro, SQL

Download the .zip containing programs shown in paper, and used in class: http://www.sascommunity.org/wiki/Image:Fehd-HOW-SQL-for-List-Processing.zip

--macro maven == the radical programmer 10:29, 30 August 2007 (EDT)