Hi Folks, In PROC COMPARE is there any way to output (to a table) only the names of the variables where a value mismatch has been found between the two datasets? So, not the variable values, just the name of the variable. I have tried using OUT=table OUTNOEQUAL OUTDIF OUTBASE OUTCOMP but this outputs all the variables which have been compared, and I only want to see the names of variables which have a value mismatch. For example, I am comparing two datasets with over 2500 variables, say 20 of these variables have unequal values, I want to extract only these variable names for use in a macro which I will create separate tables with obs pulled from both datasets to show the value differences. I know I could use PRINTALL to display this in the log but I do not have enough programming experience to know how to interrogate the log to extract this information. Is this possible? Or if I used all the OUT options above could anyone help me with the code to play find the "X" to extract the variable NAME where _TYPE_ = "DIF" from the output dataset? I hope I have managed to make this question clear. Many thanks for taking the time to read it!
... View more