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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.