As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

How to Use Proc SQL select into for List Processing

From sasCommunity
Jump to: navigation, search
How To Use Proc SQL select into for List Processing
Ronald J. Fehd


Description : The SAS® 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.
Purpose : list processing, review sql dictionaries, writing text with sql
Audience : intermediate to advanced users, and macro programmers.
Keywords : dynamic programming, list processing, macro, SQL
Information : writing alphabetical list of macro variables, processing items in list

Online resources - this zip contains the paper, handout and slides - code shown in the paper

--macro maven == the radical programmer 14:13, 21 June 2007 (EDT)