I want to create a function (in Macro terminology Macro?) that compares two numbers and returns the smaller one. This is one solution:
%macro Compare(x,y);
data test;
if &x > &y then ans = &y;
else if &x < &y then ans = &x;
else ans = &x; *They are equally big, does not matter which one I choose;
run;
proc print data=test;
%mend Compare;
What if I would like to compare two numbers and return the smalles one, BUT, if the numbers are equal return the answer "The numbers are equal". How would I do?
The alternative below does not work.
%macro Compare(x,y);
data test;
if &x > &y then ans = &y;
else if &x < &y then ans = &x;
else ans = 'The numbers are equally big'; * This does not work;
run;
proc print data=test;
%mend Compare;
Thanks.
... View more