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
To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.