topic How to find dynamic minimun value with macro? in SAS Programming

How to find dynamic minimun value with macro?

yj111 — Mon, 11 Oct 2021 20:40:57 GMT

I need find dynamic minimum value depend on _n_ , some like below,

Column K is the field I want, but the min range is changed by N. I did have some marco set up but it did not work since it did not take _N_ as numeric

%LET T=_N_;
want =MIN(OF X(&T)-X(&T+3));

anyone can help? many Appreciate here!

Re: How to find dynamic minimun value with macro?

FreelanceReinh — Mon, 11 Oct 2021 21:07:18 GMT

Hello @yj111 and welcome to the SAS Support Communities!

Do you have only six variables x1-x6 and six observations?

Then use an array, no macro variables needed:

data want;
set have;
array a[8] x1-x6 x6 x6;
if n(a[_n_],a[_n_+1],a[_n_+2]) then m=min(a[_n_],a[_n_+1],a[_n_+2]);
run;

If you don't have missing values, you can omit the IF condition.

Re: How to find dynamic minimun value with macro?

PaigeMiller — Mon, 11 Oct 2021 21:19:20 GMT

No macros needed, nor would they be a good idea here. This is a place where an ARRAY works perfectly.

data want;
    set have;
    array x x1-x6;
    if _n_>1 and _n_<6 then min_for_row=min(x(_n_+1),x(_n_));
    else if _n_=1 then min_for_row=min(of x1-x3);
    else if _n_=6 then min_for_row=x6;
run;

Re: How to find dynamic minimun value with macro?

yj111 — Mon, 11 Oct 2021 21:28:12 GMT

It works perfectly!!

Thank you!

Re: How to find dynamic minimun value with macro?

PaigeMiller — Mon, 11 Oct 2021 21:32:54 GMT

Hello @yj111 , you need to mark the reply from @FreelanceReinh as correct and not your reply that says it works perfectly as the correct answer.

Re: How to find dynamic minimun value with macro?

yj111 — Mon, 11 Oct 2021 21:49:30 GMT

thank you Paige!
small changes I made from your suggestion:

data want;
set have;

array X X1-X6;
if _n_>=1 and _n_<5 then min_for_row=min(X(_n_+1),X(_n_),X(_n_+2));

else if _n_=5 then min_for_row=min(X(_N_-1),X(_N_));
ELSE IF _N_=6 THEN MIN_FOR_ROW=X(_N_);

run;

Re: How to find dynamic minimun value with macro?

PaigeMiller — Tue, 12 Oct 2021 12:00:08 GMT

@yj111 wrote:
thank you Paige!

Repeating my earlier request:

"Hello @yj111 , you need to mark the reply from @FreelanceReinhard as correct and not your reply that says it works perfectly as the correct answer."