Select the observations to process. The WHERE statement selects for the report only the observations for departments p1 and p2 in stores in the northeast or northwest sector.

   where sector contains 'n' 
         and (department='p1' or department='p2');