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

Abstract

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

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)