If you use the WHERE function in SAS Component Language (SCL) on the
dataSetID attribute of the Variable Values List model in SAS/AF
software, the model might return all rows from the data set instead of
the requested subset of rows. For example, if you execute the following
set of statements, all of the rows in the data set are returned:

      variablevalueslist1.dataSet='sashelp.class';
      variablevalueslist1.variable='name';
      rc=where(variablevalueslist1.dataSetID,'sex="F"');

You see this behavior because the Variable Values List Model populates
the list of values as soon as the dataSet and variable attributes have
been assigned valid values. If you later apply a WHERE clause to the
data set, the list of values will not be updated unless the value of the
variable attribute changes. Therefore, you will need to reorder the
statements so the WHERE function executes after the dataSet attribute
and before the variable attribute is defined. For example,

      variablevalueslist1.dataSet='sashelp.class';
      rc=where(variablevalueslist1.dataSetID,'sex="F"');
      variablevalueslist1.variable='name';

Operating System and Release Information