|
On Tue, 27 May 2008 13:56:45 -0700, Robert Schechter
<rschechter@OCTAGONRESEARCH.COM> wrote:
>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
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)..
| 
