| This post was kindly contributed by The SAS Dummy - go there to comment and to read the full post. |
Are you a VIEWTABLE fan from the SAS Windowing Environment (a.k.a. Display Manager, DMS, PC SAS)? If so, the latest version of SAS Enterprise Guide has a new feature that you’ll love.
With the latest update to SAS Enterprise Guide 7.1 (7.11), you can now subset your data in the data grid by typing a WHERE clause filter. The new Where button appears at the top of the data grid.
Simply click the button, and type a filter expression into the text field. Hit the Enter key to apply the filter:
Just as you might expect from SAS, you can build more complex expressions too. For example, you can transform the variable that you’re comparing to lower case so that case-insensitive filters are easier to build:
And if you have continuous variables such as a date variable, you can subset by using BETWEEN to specify the boundaries you want to see:
Or transform that continuous range to a category (such as a YEAR) with a SAS function, on the fly:
SAS Enterprise Guide has always allowed you to subset data easily, but only by adding a step in the process flow (either a Query Builder task or Filter and Sort task). Now, you can accomplish this “in place”, saving time and storage as you explore. Let us know what you think of the new feature — either here in the blog comments or within the SAS Enterprise Guide community.
The post Filter your SAS Enterprise Guide data with a WHERE clause appeared first on The SAS Dummy.
| This post was kindly contributed by The SAS Dummy - go there to comment and to read the full post. |