Finding the minimum value of a group of macro variables

[blarue64]

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

[PaigeMiller]

%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