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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.