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