View Single Post
  #64  
Old 06-14-2011, 02:17 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,140
Default

Try creating indexes on your data. The index tells SAS where the unique values of the data exist on the table. This means that it only needs to search the correct partition.

Code:
proc datasets library = library_name;
	modify table_name;
	index create indicator;
	index create lunch;
run;

data table_name2;
	set table_name;
	where indicator >= 4 AND meal = 'lunch';
run;
Reply With Quote
 
Page generated in 0.10925 seconds with 9 queries