topic Attempt to append a view to itself in SAS Procedures

Attempt to append a view to itself

eagles_dare13 — Mon, 28 Jul 2014 18:01:55 GMT

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?

Re: Attempt to append a view to itself

jakarman — Mon, 28 Jul 2014 18:35:29 GMT

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.

Re: Attempt to append a view to itself

eagles_dare13 — Mon, 28 Jul 2014 18:56:02 GMT

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

Re: Attempt to append a view to itself

jakarman — Mon, 28 Jul 2014 19:16:55 GMT

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

Re: Attempt to append a view to itself

Ksharp — Tue, 29 Jul 2014 14:17:18 GMT

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