Desktop productivity for business analysts and programmers

Creating Indexes

Reply
N/A
Posts: 0

Creating Indexes

I have just imported a flat file around 2 million observations with at least 54 variables. When I do a simple Filter & Query, it takes a long while before the results are output. Is there anyway I can reduce the time to filter an output. Perhaps via indexing. Or other alternatives.
N/A
Posts: 0

Re: Creating Indexes

once you have decided on which columns you will be performing queries
see PROC DATASETS statement INDEX CREATE
at http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000247695.htm


Peter C
Valued Guide
Posts: 2,111

Re: Creating Indexes

This note shows some ways to get more efficient throughput for large data in EG

http://support.sas.com/kb/26/178.html

If you are just using the GUI in EGuide to do the analyses, the default behavior is to bring the data into EGuide and then send it on to the SAS server, effectively requiring that the data be read twice. The more data, the more noticeable the delay.
Ask a Question
Discussion stats
  • 2 replies
  • 113 views
  • 0 likes
  • 2 in conversation