SAS expertise delivered to your desktop -- on-demand and free!

Join Now

Filtering Every Which Way in SAS Enterprise Guide

by SAS Employee megak8 ‎07-12-2017 05:31 PM - edited ‎02-09-2018 12:29 PM (2,129 Views)

Did you miss the Ask the Expert session on Filtering Every Which Way in SAS Enterprise Guide? Not to worry, you can catch it on-demand at your leisure.


Watch the webinar


By the end of this hour, you will know the secrets to exploiting key data management, integration and filtering capabilities of SAS Enterprise Guide. We’ll cover:

  • Finding the tasks that conduct data management.
  • Four ways to conduct filtering.
  • Transposing data – restructuring observations and deriving new variables.
  • Using the Query Builder’s advanced expression editor. 

 The data management tasks are primarily found under Tasks -> DataThe data management tasks are primarily found under Tasks -> Data

Here are some questions and answers that were submitted during this webinar: 



Using WHERE in the data viewer, is there any way to filter for missing values?­

Yes, for character data, specify a blank ' '.  for numeric data, use  . in the expression­. If specifying . in the expression causes an error message, place quotes around the period.  Also, WHERE accepts IS MISSING. See highlighted areas below:


Data viewer without WHERE specified (all observations) – note the first row has missing data in the last variable, date:



Data viewer with WHERE [variable name] IS MISSING specified:



Data viewer after WHERE DATE IS MISSING is applied:



What type of join did you use on the tables? Inner?­

Yes – see highlighted area below:


Recommended Resources

Course: SAS Enterprise Guide 1: Querying and Reporting
Course: Creating Reports and Graphs with SAS Enterprise Guide
Book: The Little SAS® Enterprise Guide® Book


Want more tips? Be sure to subscribe to the Ask the Expert Community Library to receive follow up Q/A, slides and recordings from other SAS Ask the Expert webinars. From the Ask the Expert Library, just click Subscribe from the orange bar underneath the list of the recent articles.

NOTE: For best results when opening the attached slides, click on the “download” icon.