I think the easy way is using PROC TRANSPOSE.
I want to know if any of the values, per famid, appearing in columns dx1-dx4 are missing in columns d1-d5. If so, then which ones.
Split two dataset based on dx and d ( or you can split first and then transpose)
Then Merge the two data set.
SET1: contains dx1-dx4 variables in COL1 (in=set1)
SET1: contains d1-d5 variables in COL1 (in= set2)
merge by id and COL1. then put condition*Right now i don't have SAS with me.Code:
if set1 and not set2;