As the first step in the decommissioning of sasCommunity.org 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
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|
Fehd-HOW-SQL-exercises.zip - this zip contains the paper, handout and slides
Fehd-HOW-SQL-sas.zip - code shown in the paper
--macro maven == the radical programmer 14:13, 21 June 2007 (EDT)