Date:         Mon, 31 Mar 2008 13:40:14 -0400
Reply-To:     Chang Chung <chang_y_chung@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Chang Chung <chang_y_chung@HOTMAIL.COM>
Subject:      Re: Recursive reference - elegant approach reqd..
Comments: To: cal.yawn@GMAIL.COM

On Mon, 31 Mar 2008 09:11:26 -0700, george <cal.yawn@GMAIL.COM> wrote:
...
>        proc sql noprint;
>                create table final as
>                select * from final
>                outer union corr
>                select * from clean
>        quit;
>
>Program runs fine.. output dataset is good... But I have a warning in
>the log..
>
>WARNING: This CREATE TABLE statement recursively references the target
>table. A consequence of  this is a possible data integrity problem.
...
hi, GD,
I wonder if insert statements help like below:
cheers,
chang

/* empty shell */
data final;
  set sashelp.class(obs=0);
run;
/* append by "inserting" */
proc sql;
  insert into final
  select * from sashelp.class(where=(name="Alfred"));
  insert into final
  select *  from sashelp.class(where=(name="Mary"));
quit;