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
%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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.