07-28-2014 02:01 PM
I have this code:
proc append base = s1 (COMPRESS = YES) data = WORK.s2 () force ;
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?
07-28-2014 02:35 PM
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.
07-29-2014 10:17 AM
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;
Message was edited by: xia keshan