Using the WHERE Statement with SAS Procedures

Working with Time Series Data

Using the WHERE Statement with SAS Procedures

Use the WHERE statement with SAS procedures to process only a subset of the input data set. For example, suppose you have a data set containing monthly observations for each of several states, and you want to use the AUTOREG procedure to analyze data since 1970 for the state NC. You could use the following:

   proc autoreg data=full;
      where date >= '1jan1970'd & state = 'NC';
     ... additional statements ...
   run;

You can specify any number of conditions on the WHERE statement. For example, suppose that a strike created an outlier in May 1975, and you want to exclude that observation. You could use the following:

   proc autoreg data=full;
      where date >= '1jan1970'd & state = 'NC'
          & date ^= '1may1975'd;
     ... additional statements ...
   run;

Chapter Contents
Previous
Next
Top