View Single Post
  #63  
Old 06-14-2011, 03:09 PM
Gareth Keenan's Avatar
Gareth Keenan Gareth Keenan is offline
Member
CAS
 
Join Date: Feb 2006
Location: Garden State
Studying for #9
Favorite beer: butter
Posts: 1,308
Default Where SAS starts executing a Where in a data step

Say I have a source body of data.



And I have a SAS query, where I am interested in all records that have "Lunch" as the meal, but I'm only interested in Lunches that are at or equal to Indicator 4, is there a way to do this in SAS and minimize CPU cycles or whatever?

Specifically, I want my oracle search to not even worry about lunches, until it gets to an indicator with a value of 4 then to worry about lunches. I also know that my source data is sorted by indicator, so that the values of the indicator are from smallest to largest.

Is there a way to do this? In the very large data set I am looking at so if I could get the query to start only at the precise indicator, the query would take less time to execute.

I have this statement executing in an elementary data step, but if there is a more efficient way to do this, I would love to hear it. Thanks!

Gareth Keenan
Reply With Quote
 
Page generated in 0.10812 seconds with 9 queries