Basically my task is to code whether a new policy X is addressed in an existing policy Y. The existing policies all have file classifications showing what institutions they belong to, with the end goal of running a query that shows which institutions have any existing policies Y that address new policy X.1, X.2, X.3, etc.
However, we also want to identify when an existing policy Y partially addresses a new policy X. Instead of creating a new ‘partial’ variant for each code (i.e., x.1p, x.2p, x.3p) I was advised to create a ‘partial’ code, and in cases where an existing policy Y partially addressed a new policy X, I would code that text as both ‘x.1’ and ‘partial’. It was suggested that I could then query for instances when a ‘partial’ code overlaps with any of the other codes ‘x.1, x.2, x.3’.
Is it possible to run a matrix query that will produce ouput showing (institution file classification) x (x.1,x.2,x.3….AND ‘partial’)? In other words, that will identify which new policies X are partially addressed by each institution?
Thanks.