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?
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.
yes Iam using DI. Is there a way to get around this?
http://support.sas.com/resources/papers/proceedings10/039-2010.pdf middle of page 6
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.