DATA Step, Macro, Functions and more

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

Reply
Frequent Contributor
Posts: 82

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

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:

VariableXY
A12
B1.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

Super User
Super User
Posts: 6,502

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

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;

Ask a Question
Discussion stats
  • 1 reply
  • 239 views
  • 0 likes
  • 2 in conversation