We’re smarter together. Learn from this collection of community knowledge and add your expertise.

Filtering Every Which Way in SAS® Enterprise Guide® - Ask the Expert recording and Q&A

by SAS Employee megak8 ‎02-23-2017 11:31 AM - edited ‎02-24-2017 08:54 AM (747 Views)

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

Contributors
Your turn
Sign In!

Want to write an article? Sign in with your profile.


Looking for the Ask the Expert series? Find it in its new home: communities.sas.com/askexpert.