Filter to Include Annotation Rows

You can type one or more statements (joined by AND or OR) here to filter annotation rows before merging. Only rows that meet the condition(s) specified are included in the analysis. It is necessary to use quotation marks when filtering data using values of a character variable(e.g, Chromosome = "X") but no quotation marks are required for filtering by values of a numeric variable (for example, ProbChiSq < 3). The variable names used in this statement (for example, Chromosome, Position) must exactly match those in the Annotation Data Set.

For example, to filter only diseased individuals from a data set containing a mixed population of diseased (sick) and healthy (healthy) individuals (as indicated in a column named DiseaseStatus), you could use the following simple WHERE expression:

WHERE DiseaseStatus = ‘sick’

Note: The word where has already been entered for you.

For more information about using filter fields, see The SAS WHERE Expression.