topic Re: Creating Indexes in SAS Enterprise Guide

Creating Indexes

deleted_user — Wed, 07 Nov 2007 06:24:24 GMT

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.

Re: Creating Indexes

deleted_user — Wed, 07 Nov 2007 14:03:25 GMT

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

Re: Creating Indexes

Doc_Duke — Wed, 07 Nov 2007 14:42:46 GMT

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.