I have a custom check that matches AE and DS on USUBJID. I want to check that for a given value of DS.DSDECOD there is a specific value set for AE.AEACN. However I don’t think there are any USUBJID values in common withe these combination but what I get out of the report is all the values in DS that match the criteria in DS, just as if I hadn’t put the cross reference lunk to AE.
Is this something openCDISC just can’t do, or am I missing something here? I’ve copied the text of my rule below. I’m running v1.4 downlaoded today.
Thanks
Hugh
<val:Lookup ID=“XX0001”
Variable=“USUBJID == USUBJID”
From=“AE”
Where=“AEACN @neqic ‘NOT APPLICABLE’ @and AEACN !=‘’ @and USUBJID!=‘’”
When=“DSDECOD @eqic ‘DID NOT MEET INC/EXC CRITERIA’ @and USUBJID!=‘’”
Message=“Incorrect AE Action for screening failure”
Description=“AE.AEACN not set to NOT APPLICABLE for Screening failures”
Category=“Presence” Type=“Error”/>