https://communities.sas.com/t5/SAS-Programming/Appending-Data-into-an-existing-SAS-data-set/m-p/679674#M205260 <P>Hi All,</P> <UL class="lia-list-style-type-square"> <LI>I have about some 9 SAS datasets ( creating new datasets) and loading into a final SAS Dataset. (I know the process for this)&nbsp;</LI> <LI><SPAN style="font-family: inherit;">We run this SAS code periodically to load data into final SAS dataset (we do this in SAS DI)&nbsp;</SPAN></LI> <LI><SPAN style="font-family: inherit;">Now, I want to load data by appending into existing final SAS Dataset (not to overwrite on existing records).&nbsp;</SPAN></LI> </UL> <P>All this will be an user written transformation in SAS DI.</P> <P>Please suggest me the best way, TIA.</P> Thu, 27 Aug 2020 09:55:26 GMT VVDR 2020-08-27T09:55:26Z https://communities.sas.com/t5/SAS-Programming/Appending-Data-into-an-existing-SAS-data-set/m-p/679674#M205260 <P>Hi All,</P> <UL class="lia-list-style-type-square"> <LI>I have about some 9 SAS datasets ( creating new datasets) and loading into a final SAS Dataset. (I know the process for this)&nbsp;</LI> <LI><SPAN style="font-family: inherit;">We run this SAS code periodically to load data into final SAS dataset (we do this in SAS DI)&nbsp;</SPAN></LI> <LI><SPAN style="font-family: inherit;">Now, I want to load data by appending into existing final SAS Dataset (not to overwrite on existing records).&nbsp;</SPAN></LI> </UL> <P>All this will be an user written transformation in SAS DI.</P> <P>Please suggest me the best way, TIA.</P> Thu, 27 Aug 2020 09:55:26 GMT https://communities.sas.com/t5/SAS-Programming/Appending-Data-into-an-existing-SAS-data-set/m-p/679674#M205260 VVDR 2020-08-27T09:55:26Z https://communities.sas.com/t5/SAS-Programming/Appending-Data-into-an-existing-SAS-data-set/m-p/679675#M205261 <P>Use <A href="https://documentation.sas.com/?docsetId=proc&amp;docsetTarget=p1bjrbc5esr90on12o8vs7gyv8ue.htm&amp;docsetVersion=9.4&amp;locale=en" target="_self">PROC APPEND</A>.</P> Thu, 27 Aug 2020 10:23:08 GMT https://communities.sas.com/t5/SAS-Programming/Appending-Data-into-an-existing-SAS-data-set/m-p/679675#M205261 PaigeMiller 2020-08-27T10:23:08Z https://communities.sas.com/t5/SAS-Programming/Appending-Data-into-an-existing-SAS-data-set/m-p/679676#M205262 <P>I am tempted to suggest using proc append, but using that procedure to append data seems to be to obvious.</P> Thu, 27 Aug 2020 10:23:46 GMT https://communities.sas.com/t5/SAS-Programming/Appending-Data-into-an-existing-SAS-data-set/m-p/679676#M205262 andreas_lds 2020-08-27T10:23:46Z https://communities.sas.com/t5/SAS-Programming/Appending-Data-into-an-existing-SAS-data-set/m-p/679678#M205263 <P>As a DI user, you should use the Append transformation.</P> Thu, 27 Aug 2020 10:47:14 GMT https://communities.sas.com/t5/SAS-Programming/Appending-Data-into-an-existing-SAS-data-set/m-p/679678#M205263 Kurt_Bremser 2020-08-27T10:47:14Z