Skip to main content
Article thumbnail
Location of Repository

Subsetting Large Data Sets Created Via the Complex “WHERE ” Clause

By 

Abstract

SAS ® offers several methods to enable fast data extraction from large data sets. The discussion, here, is of techniques offered within base SAS as extraction options for the minimization of overall processing times. Our paper points rather positively to the efficient usage of the complex “WHERE ” clause coupled with its complex “OR ” logic options. Our paper then goes through several iterations of advanced processing techniques including “SORT ” and “INDEX ” then favorably compounds total processing efficiency by use of the “POINT= ” option with utilization of the SAS observation number. By combining these techniques, access speed is increased, at minimum, a factor of five or six times. A rudimentary table explains overall efficiency

Year: 2013
OAI identifier: oai:CiteSeerX.psu:10.1.1.353.4364
Provided by: CiteSeerX
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • http://citeseerx.ist.psu.edu/v... (external link)
  • http://support.sas.com/resourc... (external link)
  • Suggested articles


    To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.