On Tue, 27 May 2008 13:56:45 -0700, Robert Schechter
>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
>NOTE: No rows were selected.
>NOTE: PROCEDURE SQL used (Total process time):
> real time 0.22 seconds
> cpu time 0.01 seconds
Assign a libref to that folder and put the libref (not the host path) into
&LIB, in upper case (or use the UPCASE function in the code)..