09-04-2017 05:24 PM - edited 09-04-2017 05:24 PM
Use a WHERE clause where you exclude all observations having one or multiple variables with missing values.
You can use the CMISS() function for such a test.
09-04-2017 05:36 PM
I dont need excluding observation but prevent from not inserting them.
I found integrity constrains in proc datasets, hovewer I cant find option for preventing observation from deleting.
09-04-2017 05:43 PM
Please explain in detail what you have and what you're trying to achieve so can understand your problem and give you a suitable answer.
Using Integrity Constraints will protect your table against Inserting/Updating rows with values you don't want. BUT if an integrity constraint gets hit your job will throw an error and fail. Is that what you want?
There are no integrity constraints for "do not delete" except for referential integrity which prevents deletion of parent records when there are dependent child records in another table.