Date:         Fri, 3 Dec 2004 02:22:37 -0800
Reply-To:     Xavier Autret <xav_x@NOOS.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Xavier Autret <xav_x@NOOS.FR>
Organization: http://groups.google.com
Subject:      9.1.3 Proc sql Message => WARNING: This CREATE TABLE statement
              recursively references the target
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I've got the same message in 9.1.3

Can I turn on an option for switching this off?
Thks

Xavier

**************************************************************************
De :Crawley-Boevey, Richard RM (Richard.Crawley-Boevey@STANDARDBANK.CO.ZA)
Objet :V9.1.2 Warning not in 8.2

View this article only
Groupes de discussion :comp.soft-sys.sas
Date :2004-05-28 11:10:28 PST

Hi

The following code runs fine in V8.2, but when I run it in V9.1.2, it
produces the following warning:

WARNING: This CREATE TABLE statement recursively references the target
table. A consequence of
         this is a possible data integrity problem.

I realise why the warning occurs, but would not like to see it. Is there any
way of switching this off?

The code is:

DATA CardData;
INPUT Acc_No Balance;
CARDS;
1 1000
2 1500
3 2000
4 2500
;

DATA LimitData;
INPUT Acc_No Limit;
CARDS;
1 1500
2 2000
3 2500
5 3000
;
RUN;

PROC SQL;
CREATE TABLE CardData
AS
SELECT COALESCE(A.Acc_No, B.Acc_No) AS Acc_No, A.Balance, B.Limit
FROM CardData AS A Full Join LimitData AS B
ON A.Acc_No = B.Acc_No
;
QUIT;

Thanks

Richard Crawley-Boevey