Robert,

The problem seems to be with your macro variable LIB.

SYMBOLGEN: Macro variable LIB resolves to H:\CLIENT\client\CDO\project \02 DEVELOPMENT\ISE\PROGRAMMING\DATA\RAW

which doesn't look like a libname to me.

Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com

"Robert Schechter" <rschechter@OCTAGONRESEARCH.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 05/27/2008 04:57 PM Please respond to rschechter@OCTAGONRESEARCH.COM

To SAS-L@LISTSERV.UGA.EDU cc

Subject SQL meaning for "No rows were selected" message

Any idea why I'm being told "No rows were selected"

33 proc sql; 34 select upcase(memname) into : hitlist separated by " " 35 from dictionary.tables 36 where libname in ("&lib") ; SYMBOLGEN: Macro variable LIB resolves to H:\CLIENT\client\CDO\project \02 DEVELOPMENT\ISE\PROGRAMMING\DATA\RAW NOTE: No rows were selected. 37 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.22 seconds cpu time 0.01 seconds