Help using Base SAS procedures

Insert into table, then sort the data without changing destination table name?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 18
Accepted Solution

Insert into table, then sort the data without changing destination table name?

I have a process that inserts data into a permanent table, after the insert, the permanent table has to be sorted. The should run about once a month.

I wrote a create table statement where the source and destination are the same permanent table and get the following error: "This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem."

 

I googled it and found there's an option to disable the warning, but I'm wondering if it's bad practice to leave it like this, and if so, how do I write the program so as to not risk data integirty.

 

Thanks in advance.

proc sql;
insert into perm_table
select * from source;

create table perm_table as
select * from perm_table
order by id;
quit;

Accepted Solutions
Solution
‎03-10-2017 02:15 PM
Super User
Posts: 11,343

Re: Insert into table, then sort the data without changing destination table name?

Is there something wrong with using Proc Append and then Proc Sort?

 

proc append base=perm_table data=source;

run;

 

proc sort data=perm_table;

   by id;

run;

View solution in original post


All Replies
Solution
‎03-10-2017 02:15 PM
Super User
Posts: 11,343

Re: Insert into table, then sort the data without changing destination table name?

Is there something wrong with using Proc Append and then Proc Sort?

 

proc append base=perm_table data=source;

run;

 

proc sort data=perm_table;

   by id;

run;

Occasional Contributor
Posts: 18

Re: Insert into table, then sort the data without changing destination table name?

No, I forget to use other procs sometimes because I'm more familiarized with sql.

 

Thank you.

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 202 views
  • 1 like
  • 2 in conversation