| 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
| 
