BookmarkSubscribeRSS Feed
eagles_dare13
Obsidian | Level 7

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?

4 REPLIES 4
jakarman
Barite | Level 11

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.

---->-- ja karman --<-----
eagles_dare13
Obsidian | Level 7

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

Ksharp
Super User

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

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 2085 views
  • 3 likes
  • 3 in conversation