https://communities.sas.com/t5/SAS-Procedures/Integrity-Constraints-multiple-var-condition/m-p/14559#M2344 I am working with Integrity constraints and want to be able to use a second var in the IC condition.<BR /> <BR /> ic create X_chk = check <BR /> (where= (( Y = 1 and X ~=999) or (Y =2 and X = 999)))<BR /> <BR /> 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.<BR /> <BR /> Thanks Mon, 03 May 2010 19:45:10 GMT veblen 2010-05-03T19:45:10Z https://communities.sas.com/t5/SAS-Procedures/Integrity-Constraints-multiple-var-condition/m-p/14559#M2344 I am working with Integrity constraints and want to be able to use a second var in the IC condition.<BR /> <BR /> ic create X_chk = check <BR /> (where= (( Y = 1 and X ~=999) or (Y =2 and X = 999)))<BR /> <BR /> 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.<BR /> <BR /> Thanks Mon, 03 May 2010 19:45:10 GMT https://communities.sas.com/t5/SAS-Procedures/Integrity-Constraints-multiple-var-condition/m-p/14559#M2344 veblen 2010-05-03T19:45:10Z https://communities.sas.com/t5/SAS-Procedures/Integrity-Constraints-multiple-var-condition/m-p/14560#M2345 The syntax above is valid. Mon, 03 May 2010 21:28:44 GMT https://communities.sas.com/t5/SAS-Procedures/Integrity-Constraints-multiple-var-condition/m-p/14560#M2345 ChrisNZ 2010-05-03T21:28:44Z https://communities.sas.com/t5/SAS-Procedures/Integrity-Constraints-multiple-var-condition/m-p/14561#M2346 Thanks Chris. I appreciate the quick response. Mon, 03 May 2010 23:31:22 GMT https://communities.sas.com/t5/SAS-Procedures/Integrity-Constraints-multiple-var-condition/m-p/14561#M2346 veblen 2010-05-03T23:31:22Z