Help using Base SAS procedures

recreating table w/o losing integrity

Reply
Super Contributor
Posts: 326

recreating table w/o losing integrity

Hi,

My code looks like this:

proc sql;
create table loan as
select * from loan left join x_loan
on loan.rkid = x_loan.rkid;
quit;

rkid is a primary key and with this code of mine integrity is a problem since i recreated the table loan. Is there a way to recreate a table without the integrity? Or are there any steps i can do to achieve what i intend to do?

Thanks!
Super Contributor
Super Contributor
Posts: 3,174

Re: recreating table w/o losing integrity

You may find useful SAS DOC and supplemental technical papers at the SAS Support website http://support.sas.com/ -- here is one topic related paper from a SAS conference to consider.

Scott Barry
SBBWorks, Inc.


Integrity Constraints and Audit Trails Working Together
Gary Franklin, SAS Institute Inc., Austin, TX
Art Jensen, SAS Institute Inc., Englewood, CO

http://www2.sas.com/proceedings/sugi25/25/aa/25p008.pdf
Ask a Question
Discussion stats
  • 1 reply
  • 87 views
  • 0 likes
  • 2 in conversation