topic Re: Viewing table in SAS Enterprise Guide in SAS Enterprise Guide

Viewing table in SAS Enterprise Guide

Aasth — Mon, 15 Apr 2019 16:33:53 GMT

Hi everyone,

How can I make sure tat I see just a few rows of a table view instead of SAS EG running a full query when I access a large table in SAS Enterprise guide?

Re: Viewing table in SAS Enterprise Guide

jebjur — Mon, 15 Apr 2019 16:47:50 GMT

Just to verify, when you say 'large table'. are you referring to a large SAS data set in Enterprise Guide, or a database table? And are you simply opening the table in the data grid, or using the query builder? If you are opening a large database table in the data grid, make sure you go to Tools - Options - Data - Performance, and set a limit for the option 'Maximum number of rows to display in the data grid with SAS/Access data.

Re: Viewing table in SAS Enterprise Guide

Aasth — Mon, 15 Apr 2019 17:46:27 GMT

I am referring to a database table. We are connected to DB2 by SAS/ACESS

Re: Viewing table in SAS Enterprise Guide

jebjur — Mon, 15 Apr 2019 18:21:08 GMT

If you are opening a large database table in the data grid, make sure you go to Tools - Options - Data - Performance, and set a limit for the option 'Maximum number of rows to display in the data grid with SAS/Access data.

Re: Viewing table in SAS Enterprise Guide

TomKari — Tue, 16 Apr 2019 02:52:07 GMT

One issue to watch out for. If you're looking at a view, the background database engine might need to process and create the entire view before showing you anything. This can take quite a while.

Tom