04-13-2016 01:22 AM
I found multiple (more than 100) Integrity constraints on a single table and i am not able to drop this(warning: IC doesnot exist) .Dont know why this happened. i know i can copy the content delete the table and recreate this but is there any other better way so that i can drop all these constraints ? please find attachment i see multiple constraints when i run describe command.
04-13-2016 05:02 AM
You can delete all these Integrity Constraint via keyword _ALL_ :
data have; set sashelp.class; run; proc datasets library=work nodetails nolist; modify have; ic create age = check(where=(age between 1 and 99)); contents data=have; quit; proc datasets library=work nodetails nolist; modify have; ic delete _ALL_; contents data=have; quit;
04-13-2016 11:00 AM
Please post the exact code run and log results.
Also, do you have permissions to write and modify datasets in the library where the data file exists? By any chance is it a database and not native SAS dataset?