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
... View more