Finding the minimum value of a group of macro variables

blarue64 — Thu, 10 Mar 2022 19:11:04 GMT

Hi,

I am trying to find out if there is a simple way to get the min or max of a group of macro variables containing numeric values. For example:

%let a = 5;

%let b = 7;

%let c = 6;

%let d = 9;

Sometimes the value of one of these variables may change and I would like to always keep track of which has the maximum value, something like a macro version of min or max like %let maxval = %max(&a, &b, &c, &d);

These macro variable values contain the number of "value pairs" in different datasets, and by knowing the maximum number I can dynamically create enough columns for a combined report. Any suggestions would be helpful.

Thanks,

Bob

Re: Finding the maximum value of a group of macro variables

PaigeMiller — Thu, 10 Mar 2022 19:18:56 GMT

%let maxval = %sysfunc(max(&a, &b, &c, &d));

Could you please edit the Subject line on your ORIGINAL post so that it refers to maximum, and not minimum. Thanks

topic Re: Finding the maximum value of a group of macro variables in SAS Programming

Finding the minimum value of a group of macro variables

Re: Finding the maximum value of a group of macro variables