Creating Indexes

[deleted_user]

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.

[deleted_user]

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

[Doc_Duke]

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.