topic Re: Append single source table into permanent table (i.e. add rows) in SAS Enterprise Guide

Append single source table into permanent table (i.e. add rows)

David_T — Fri, 02 Dec 2016 05:04:43 GMT

Hello,

In SAS Enterprise Guide (7.1), I have a temporary current snapshot data table that I want to append into a permanent table. The permanent table would then hold multiple snapshots of the data and keep that history. The columns between the two tables are exactly the same. The permanent table has already been created and the initial data set has been loaded, now I want to add a new snapshot to the permanent table.

I have attempted to use the 'Append Table' task (from one WORK table), but it overwrites the data in the permanent table rather than adding new rows to it. There is just one source temporary table.

Below is an example of some code I have attempted to use, but it isn't complete and doesn't work.

DATA PERMANENT.SNAPSHOT_ALL;
SET WORK.SNAPSHOT_CURRENT;
RUN

Re: Append single source table into permanent table (i.e. add rows)

Reeza — Fri, 02 Dec 2016 05:28:34 GMT

Append is the correct task for this. Can you post a snapshot of your settings that didn't work?

Otherwise

proc appemd base=permanent.snapshot_all data=snapshot.curremt;

run;

Re: Append single source table into permanent table (i.e. add rows)

David_T — Fri, 02 Dec 2016 05:47:38 GMT

Hi Reeza,

Thank you, that PROC APPEND function worked. I used:

proc append base=PERMANENT.SNAPSHOT_ALL data=WORK.SNAPSHOT_CURRENT;

run;