Did you miss the Ask the Expert session on Filtering in SAS Enterprise Guide? Not to worry, you can catch it on-demand here https://www.sas.com/en_us/webinars/filtering-enterprise-guide/register.html
If you did participate, its Q&A is below.
Is there a way to see the complete query after adding all the filters?
Yes. The query builder generates PROC SQL code. In each task you can see the code by clicking on the preview button.
If I wanted to make multiple filters shown as different output files, can I have multiple filter steps that point to the same underlying results?
Yes, you can use multiple tasks and point to the same underlying data in order to create separate and distinct output files.
I only see SAS Report and HTML, how can I turn on other output formats?
Under Tools -> Options -> Results General, you can choose other forms of output.
Does Excel or PowerPoint need any kind of Add-ins? I did not see them as options in my EG (version 6.1M1HF1).
This functionality requires a later release of Enterprise Guide 7.n. You should not need any additional add-ins as long as the SAS session that you are connecting to is version 9.4 M3 or later with the appropriate corresponding version of Enterprise Guide.
Does SAS editor accept T-SQL script without tweaking the script? Does that include CASE and IF-ELSE statements?
From a coding perspective, SAS will accept WHERE clauses that are appropriate for PROC SQL in Base SAS. This can be supplied through the point and click interface as well. That includes CASE statement, as that is the way that SQL handles conditional processing. SAS implemented ANSI standard SQL, so this might be familiar to SQL users. If then ELSE is appropriate for DATA Step programming.
How to rename variables on SAS EG?
In the Query Builder window, you can highlight the variable name in the variable list window. This should highlight the name and allow you to type the new name.
Are these functions also available in base SAS, data steps?
Yes, they are available in the DATA step, which is part of Base SAS.
What is the general breakdown of SAS users? Percent that use SAS, EG, and Studio? Rough estimates?
http://www.sas.com/en_us/company-information.html#stats
Are these filtering often applicable or available in other SAS tools (For example SAS Visual Analytics/Statistics) or Enterprise Miner 14.3?
Yes, although SAS Enterprise Guide is particularly well-suited to filtering because it supports the 4 techniques that we reviewed:
1) Filter and sort
2) Query Builder
3) Task filters
4) Filtering in code
