Viewing table in SAS Enterprise Guide

[Aasth]

 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?

[jebjur]

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.

[Aasth]

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

[jebjur · Accepted solution]

 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.

[TomKari]

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