Sometimes I want to interrogate data down in the murky depths of a large table (e.g. >100k rows).
Unfortunately SAS EG only lets me see 10,000 rows.
I'm not aware of an obvious option/setting to make this bigger.
I'm forced to export the data into an external file before I can view all the data. This is an unnecessary click-fest. Especially when I am trying to interrogate multiple large tables (e.g. if i am debugging/sense-checking/quick-checking/verifying). I just want SAS to show my rows 10,001 to N as I scroll down to the bottom of the table.
Also, on a similar vein, I want to quickly copy-paste more than 10,000 rows of data from SAS EG to a spreadsheet/text editor. I don't want to go through the SAS-right-click-and-select-export-method-from-menu-just-cos-i-have-10000-plus-rows feature (because it is a click-fest). A quick Ctrl-c, Ctrl-v is a lot faster and convenient especially if the copy-paste is just a once-off, and I want to do many Ctrl-c, Ctrl-v on a few tables to do some quick checking.
Incidentally, when selecting data, ctrl-c should copy data and ctrl-shift-c should copy data with column headers in my opinion.
Also, when viewing a large table in SAS, click-holding the scroll bar conveniently tells us "Row X of N". Except, when N is a large number, it tells us "Row X of 800+" or "Row X of 1650+". That's rather uninformative. I'd like to know how big N is. Why don't we just permanently display N somewhere on a status bar in SAS EG. I am aware you can right-click the table, click [Properties], click [Advanced] and see the number of [Rows]. Except, for large N, the [Rows] displays [Unknown], which is also unhelpful and in addition, right-clicking is just another click-fest if you are doing quick row size checks for multiple tables.