Allow a Form View option for the Data Grid in SAS/Enterprise Guide
on 05-20-201305:23 PM - last edited on 10-10-201511:20 PM by LainieH
I think it would be a great idea to provide a built-in Form View in the Data Grid in SAS/Enterprise Guide so that I can view my datasets one record at at time, where each row is laid out like a form.
In past lives I have used Proc FSBrowse to browse datasets, one record at a time, and this is really useful, especially when the dataset has many columns (ie more than would normally fit on window width). Whilst FSBrowse looks a little clunky, its utility more than makes up for this. With the Data Grid, having to constantly scroll left to right and back again or re-arrange columns so that they can be seen side-by-side for comparison purposes is confusing and leads to fatigue, which leads to errors.
This Form View option would also allow:
WHERE Clauses to be applied to the dataset, live, without having to go via a secondary Filter or Query Task
WHERE Clauses could be cumulative and they could be removed as well
Variables could be temporarily hidden for the purposes of browsing the dataset.
A given record could be printed (or at least subject to a Windows screenshot) to allow two or more records to be eyeballed, on the desk.
I understand that there are some user written Add-Ins available that offer a Form View, but most client sites that I work on will not have any non-SAS supplied software installed.
I have attached a screenshot showing two records from the same demo dataset as an example.