Date:         Wed, 6 Sep 2000 11:35:37 -0700
Reply-To:     "Deppman, Laurie M" <Laurie.Deppman@DOH.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Deppman, Laurie M" <Laurie.Deppman@DOH.WA.GOV>
Subject:      Where Clause
Content-Type: text/plain; charset="iso-8859-1"

Does anyone know if the syntax in my where clause is correct? Why am I
getting the following message?

380
381  data craig (keep=cert city cnty_res county street zipcode zip_4);
382  merge test (where=(substr(cert,11,1) eq 'O' or 'P' or 'R') in=a)
383          geo.bd99fin (where=(substr(cert,11,1) eq 'O' or 'P' or 'R')
in=b)
384          geo.unbd99fin (where=(substr(cert,11,1) eq 'O' or 'P' or 'R')
in =c);
385  by cert;
386  if a and not b and not c;
387  run;

NOTE: There were 80052 observations read from the dataset WORK.TEST.
      WHERE 1 /* an obviously TRUE where clause */ ;
NOTE: There were 115429 observations read from the dataset GEO.BD99FIN.
      WHERE 1 /* an obviously TRUE where clause */ ;
NOTE: There were 8417 observations read from the dataset GEO.UNBD99FIN.
      WHERE 1 /* an obviously TRUE where clause */ ;
NOTE: The data set WORK.CRAIG has 0 observations and 7 variables.
NOTE: DATA statement used:
      real time           58.93 seconds