Creating a Simple Data Selection in SAS Field Quality Analytics
This post is the next in a series of posts about SAS Field Quality Analytics. In my previous post I talked about the different types of alerts groups within SAS Field Quality Analytics. As mentioned in my previous post alert groups can be a good place to start if you want to see which problems exist in your warranty data. The purpose of this post is to explain data selections, including when they are used and how to create them.
What is a Data Selection
A data selection is a saved set of instructions that are used to subset data for analysis. Data selections define which product data and event data will be included in an analysis. You must specify a data selection when you create any analysis, including an alert group. Data selections can also be used to create a launch, which allow you to manage or analyze your data outside of SAS Field Quality Analytics.
There are two types of data selections, a simple data selection and a combined data selection. This post will focus on simple data selections. For more details about combined data selections see the data selection concepts section in the SAS® Field Quality Analytics on SAS® Viya® course (referenced below).
Simple data selections can consist of multiple groupings of both product and event data. In a simple data selection, the OR operator is used within an attribute and the AND operator is used between attributes. Consider the following data selection summary, which consists of the variables and selections:
Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.
There are 2 variables selected, Production Year, and Model Code. Within each of these variables selected specific values have been selected and an OR operator is used within each of these values. Between the different variable values selected the AND operator is used. For this example, the data that the data selection will include can be when Production Year is 2009 OR 2010 OR 2011 OR 2012 OR 2013 OR 2014 AND when Model Code is Abyss OR Galacto OR Gemini.
Creating a Simple Data Selection
To create a simple data selection, navigate to the data selection workspace. Select new and select Simple data selection:
Enter a name and description. (A description is optional.):
Next, you select the variables you want to include in the data selection by moving the variable from the available variables box to the selected variables box:
Next you select the values to create the selection criteria. The method that you use to select values depends on the variable. For all methods, you can choose whether to include or exclude the values that you specify. For example, the year values can be added by selecting add:
Then choosing the values to add:
Once all of the variables and their values have been added make sure to save your data selection. You can view a summary of the selected items:
The data selection is then ready to use in an alert group, an analysis, or a launch. Future posts will delve more into working with alerts and specific analyses. For additional information, see the SAS® Field Quality Analytics on SAS® Viya® course which is part of the SAS Internet of Things Learning Subscription.
Find more articles from SAS Global Enablement and Learning here.
