Desktop productivity for business analysts and programmers

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

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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

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

Accepted Solutions
Solution
‎12-02-2016 12:45 AM
Super User
Posts: 19,157

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

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;

View solution in original post


All Replies
Solution
‎12-02-2016 12:45 AM
Super User
Posts: 19,157

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

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;

New Contributor
Posts: 2

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

Hi Reeza,

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

 

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

run;
☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 330 views
  • 0 likes
  • 2 in conversation