You might also want to select rows for your report based on a condition. To select observations, you can use the WHERE statement, just as you have learned to do with PROC PRINT.

Example

The following WHERE statement specifies that only observations that have the value LON or PAR for the variable Dest be printed.

     proc report data=flights.europe nowd;
        where dest in ('LON','PAR');
        column flight orig dest mail freight revenue;
     run;