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.
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.