topic Re: recreating table w/o losing integrity in SAS Procedures

recreating table w/o losing integrity

milts — Fri, 13 Mar 2009 03:11:08 GMT

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!

Re: recreating table w/o losing integrity

sbb — Fri, 13 Mar 2009 07:56:14 GMT

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