topic Re: Options for running a Query builder faster in SAS Enterprise Guide

Options for running a Query builder faster

Riana — Wed, 01 Mar 2017 07:43:15 GMT

Hi,

I'm running a project in SAS EG with two queries but it hangs when I run it . The dataset is not so large, 200 rows. What can be the problem? is there any option for queries(query builder) that can be used for running faster?

Doriana

Re: Options for running a Query builder faster

Kurt_Bremser — Wed, 01 Mar 2017 07:54:39 GMT

PLEASE POST THE CODE.

You already have posted here quite a lot, so by now you should know that code and log are ESSENTIAL in finding mistakes. If you can't get at the log because of a hang or complete crash, at least post the code.

Re: Options for running a Query builder faster

ChrisHemedinger — Wed, 01 Mar 2017 13:08:36 GMT

If the Query Builder window is hanging up, please share more details about the data:

- is it a database table?

- is it a local SAS data set file (as opposed to a library member)?

- is your SAS server a remote machine, and where is it (on local network or far-flung across the country/world)?

In general, the Query Builder should not be slow/unresponsive. So if you're experiencing this, I'd say there is something wrong...