Date:         Thu, 23 Jul 2009 18:30:08 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: strange error from dictionary tables
Comments: To: shankar.stat@GMAIL.COM

Shankar,

Take a look at Roy Pardee's suggestion at:
http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0705C&L=sas-
l&P=R26835&D=1&H=0&O=D&T=1

http://xrl.us/be5fdw

Basically, he suggests adding another condition to your WHERE statement,
namely: where memtype ne 'VIEW'

Let SAS-L know if doing that corrects the problem.

Art
-------
On Thu, 23 Jul 2009 11:04:04 -0700, Shankar <shankar.stat@GMAIL.COM> wrote:

>hi all, thanks for the inputs;
>
>hi Joe, what I have is a SAS data set, not a view;
>
>Lou, libref is being assigned at the start of the batch and cleared at
>the end;
>While I am positive that the batch has ended and there are no child
>processes hanging around, I will watch out for this possibility;
>
>
>and Mike, thanks for that nice explanation about how dictionary tables
>work!
>
>When I first saw that error in the log, I assumed that there might be
>a reference to PRICE_Z somewhere;
>
>I went through the code, but that data set is not referenced
>anywhere;
>
>The call to dictionary tables is followed by some data steps, and
>finally there is a call to proc datasets;
>
>I started removing a block of code at a time, and the error goes away
>when proc sql code is commented out;
>Also, if that sql code is run stand-alone, the error appears, based on
>which I suspected this has something to do with dictionary tables;
>
>
>The log basically looks like this:
>
>**************************************************************************
*********************
>
>NOTE: There were 15124 observations read from the data set
>WORK.SRC_DEPOSIT_RATES.
>NOTE: The data set WORK.DEPOSIT_RATES has 15124 observations and 13
>variables.
>NOTE: DATA statement used (Total process time):
>      real time           0.04 seconds
>      cpu time            0.04 seconds
>
>
>ERROR: File CBSN.ALLPRICE_Z.DATA does not exist.
>NOTE: PROCEDURE SQL used (Total process time):
>      real time           6.50 seconds
>      cpu time            1.89 seconds
>
>
>
>NOTE: There were 330 observations read from the data set
>PTLDATA.REQUEST_LIST.
>NOTE: The data set WORK.DYMLIST has 330 observations and 14 variables.
>NOTE: DATA statement used (Total process time):
>      real time           0.01 seconds
>      cpu time            0.00 seconds
>**************************************************************************
**************************
>
>
>Thanks,
>Shankar