Help using Base SAS procedures

Integrity Constraints-multiple var condition

Reply
Contributor
Posts: 32

Integrity Constraints-multiple var condition

I am working with Integrity constraints and want to be able to use a second var in the IC condition.

ic create X_chk = check
(where= (( Y = 1 and X ~=999) or (Y =2 and X = 999)))

Can I use two vars in an simple integrity constraint or do I have to check it against a second table? Or is there some other method that I'm missing.

Thanks
PROC Star
Posts: 1,760

Re: Integrity Constraints-multiple var condition

The syntax above is valid.
Contributor
Posts: 32

Re: Integrity Constraints-multiple var condition

Thanks Chris. I appreciate the quick response.
Ask a Question
Discussion stats
  • 2 replies
  • 276 views
  • 0 likes
  • 2 in conversation