DATA Step, Macro, Functions and more

Index Utilization

Reply
Contributor
Posts: 57

Index Utilization

I have a large dataset and set up indexes on a couple of columns. Then I wrote a PROC SQL to take advantage of the indexes to get the data from this dataset, but it still takes a long time to return the results. I am wondering if SAS actually uses the indexes to speed up the data retrieval. Does SAS offer any tool to analyze a query? Oracle offers the EXPLAIN command for users to analyze a query to see if it uses the index as intended. So I wonder SAS has a similar tool.
Valued Guide
Posts: 2,175

Re: Index Utilization

try the _method option like
proc sql _method ;
it will indicate which methods are used
there are papers on the feature
Super User
Posts: 9,687

Re: Index Utilization

Hi.
Do you use proc sql to create index? and using proc contents to view the index is really created?
Super Contributor
Super Contributor
Posts: 3,174

Re: Index Utilization

Suggestion to the OP: share your code, as part of the SAS-generated log (not just your code statements). This would include both index-creating code and any subsequent retrieval code - using COPY / PASTE in your forum post-reply.

Scott Barry
SBBWorks, Inc.
Contributor
Posts: 57

Re: Index Utilization

@Peter Thanks! proc sql _method is exactly what I am looking for.



sbb sounds like a mod but useless.
Ask a Question
Discussion stats
  • 4 replies
  • 145 views
  • 0 likes
  • 4 in conversation