Database Management White Papers

DIGITS and DATES - The SQL Procedure Goes "Loopy"

Overview Although PROC SQL, with its descriptive approach to programming, is very good at manipulating data, it lacks an important feature that is found in traditional procedural programming languages - the ability to loop over a range of values, some of which might not exist in an input data set. This paper describes how to create and use utility data sets to simulate looping in PROC SQL.

Further White Paper Details
PublisherSAS Institute File FormatPDF
Date PublishedFebruary 2006
FormatWhite Papers   
Topics

Quick Sitemap Links: