Chapter Contents


The FSLETTER Procedure

WHERE Statement

Specifies a condition or set of conditions that observations in an input data set must meet in order to be used for filling variable fields.

Restriction: The WHERE statement is valid only when the DATA= option is used in the PROC FSLETTER statement to identify the data set.

WHERE expression;


expression is any valid WHERE expression that includes one or more of the variables in the input data set. Refer to the description of the WHERE statement in SAS Language Reference: Dictionary for details about the operators and operands that are valid in WHERE expressions.

Using the WHERE Statement

By default, when you use the DATA= option in the PROC FSLETTER statement, the FSLETTER procedure generates a copy of the document for every observation in the data set. If you do not need a copy for every observation, you can use the WHERE statement to generate copies for only observations that meet a specified condition or list of conditions.

For example, to print form letters for only observations in which the value of the variable YEAR is less than 5, follow the PROC FSLETTER statement with this statement:

where year<5;

In this case, the FSLETTER procedure uses only observations that meet the specified condition. No documents are printed for observations that do not satisfy the condition.

Chapter Contents



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.