Im trying to compare two variables and insert variable X into macro if conditions are met

[Xamius32]

And create another dataset and add a row to the second dataset explaining the problem with X variable, so I any number of variables/explinations would need to be added to other dataset. So I am trying to figure out how to do this in an array (IE add 3 variables to the array and then add a row for each variable to say this variable has a problem)

My dataset looks like:

Variable	X	Y
A	1	2
B	1	.5

So the condition might be if X>Y then add a variable to array, and then I want to create dataset test and add a row saying variable X has X>Y

Is this possible and does it make sense

[Tom]

Sounds like you want to create a problem report.  Typically you would include the id variables (so someone can find the offending row), then rule and the key values that violate the rule.

data want ;

    set have ;

    length rule $50 values $50 ;

    keep id rule values ;

    if x > y then do;

       rule = 'X>Y' ;

      values=catx(' ',catx('=','X',x),catx('=','Y',y));

      output;

   end;

run;