Thanks to everyone who participated in the April 26, 2017 Ask the Expert Webinar 'Filtering Every Which Way in SAS Enterprise Guide.' Here are the questions that were submitted during that meeting, along with their answers, plus the slides and recording link.
Click here to join
Event password: SAS
Case should only be an issue if you are comparing text values. You could choose to use the UPCASE or LOWCASE functions to help make consistent comparisons to text.
There is a DISTINCT keyword that is available with SQL. In the Query Builder, click the Select Data tab, and select the Select distinct rows only check box.
Yes, you can edit just as you would other content in PowerPoint.
The new variable names were derived from the values of the column that is being split. That is now part of your new data, so I wonder why you would want to drop them?
Those are values such as confidence level values L95, U95 that are included in forecasts.
From the Query Builder, select computed columns, New -> Advanced expression.