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.
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:
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?
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.