Skip to main content
Article thumbnail
Location of Repository

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



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:
Provided by: CiteSeerX
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • (external link)
  • (external link)
  • Suggested articles

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