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

Xamius32 — Thu, 25 Jun 2015 15:57:56 GMT

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

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

Tom — Thu, 25 Jun 2015 16:39:57 GMT

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;

topic Re: Im trying to compare two variables and insert variable X into macro if conditions are met in SAS Programming

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

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