SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

What is difference between: "Insert Rows" and "Append" in SAS DI transformations?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

What is difference between: "Insert Rows" and "Append" in SAS DI transformations?

Hi All, What is the difference between: "Insert Rows" and "Append" in SAS DI transformations? Is it on the performance? Are they equal in terms of features / results which they give. When I should use first one and when second one? Thanks in advance, Piotr

Accepted Solutions
Solution
a month ago
Super User
Posts: 5,490

Re: What is difference between: "Insert Rows" and "Append" in SAS DI transformat

Posted in reply to Peter_Wine
It's about syntax, either PROC APPEND or PROC SQL.
Usually it's no perfoŕmance difference, especially when you use the default behaviour of using views as output in preceeding transformations.
Data never sleeps

View solution in original post


All Replies
Solution
a month ago
Super User
Posts: 5,490

Re: What is difference between: "Insert Rows" and "Append" in SAS DI transformat

Posted in reply to Peter_Wine
It's about syntax, either PROC APPEND or PROC SQL.
Usually it's no perfoŕmance difference, especially when you use the default behaviour of using views as output in preceeding transformations.
Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 126 views
  • 0 likes
  • 2 in conversation