Attempt to append a view to itself

[eagles_dare13]

I have this code:

proc append base = s1 (COMPRESS = YES) data = WORK.s2 () force ;

MPRINT(ETLS_LOADER):   run;

I get:

NOTE: Appending WORK.s2 to s1.

ERROR: Attempt to append a view to itself.

Now how am I appending view to iself...I did not write proc append base = s1 data = s1...so what is the problem.

It is true that s2 is a dataset that is 'derived' from s1 throguh a series of transformations....but is that a problem?

[jakarman]

Are you using DI?   (ETLS_Loader) the generated is often based on using views. 
I can imagine proc append does not like that as it optimized to extend a physicial dataset.

[eagles_dare13]

yes  Iam using DI. Is there a way to get around this?

[jakarman]

http://support.sas.com/resources/papers/proceedings10/039-2010.pdf middle of page 6

[Ksharp]

View is just a bunch of code . It can't be true to append a view into another view.

data class;
 set sashelp.class;
run;


proc sql;
create view cl as
 select * from class;


create view append as
 select * from cl
 union all corr
 select * from cl
 ;
quit;

Xia Keshan

Message was edited by: xia keshan