https://communities.sas.com/t5/SAS-Data-Management/What-is-difference-between-quot-Insert-Rows-quot-and-quot-Append/m-p/412932#M12615 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 Mon, 13 Nov 2017 15:06:09 GMT Peter_Wine 2017-11-13T15:06:09Z https://communities.sas.com/t5/SAS-Data-Management/What-is-difference-between-quot-Insert-Rows-quot-and-quot-Append/m-p/412932#M12615 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 Mon, 13 Nov 2017 15:06:09 GMT https://communities.sas.com/t5/SAS-Data-Management/What-is-difference-between-quot-Insert-Rows-quot-and-quot-Append/m-p/412932#M12615 Peter_Wine 2017-11-13T15:06:09Z https://communities.sas.com/t5/SAS-Data-Management/What-is-difference-between-quot-Insert-Rows-quot-and-quot-Append/m-p/412943#M12616 It's about syntax, either PROC APPEND or PROC SQL.<BR />Usually it's no perfoŕmance difference, especially when you use the default behaviour of using views as output in preceeding transformations. Mon, 13 Nov 2017 15:50:51 GMT https://communities.sas.com/t5/SAS-Data-Management/What-is-difference-between-quot-Insert-Rows-quot-and-quot-Append/m-p/412943#M12616 LinusH 2017-11-13T15:50:51Z