How to Use the MIN Function in SAS (With Examples)

You can use the MIN function in SAS to find the smallest value in a list of values.

Here are the two most common ways to use this function:

Method 1: Find Minimum Value of One Column in Dataset

proc sql;
    select min(var1)
    from my_data;
quit;

Method 2: Find Minimum Value of One Column Grouped by Another Column in Dataset

proc sql;
    select var2, min(var1)
    from my_data;
    group by var2;
quit;

The following examples show how to use each method with the following dataset in SAS:

/*create dataset*/
data my_data;
    input team $ points;
    datalines;
A 12
A 14
A 19
A 23
A 20
A 11
A 14
B 20
B 21
B 29
B 14
B 19
B 17
B 30
;
run;

/*view dataset*/
proc print data=my_data;

Note: The MIN function automatically ignores missing values when calculating the minimum value of a list.

Example 1: Find Minimum Value of One Column in Dataset

The following code shows how to calculate the minimum value in the points column of the dataset:

/*calculate minimum value of points*/
proc sql;
    select min(points)
    from my_data;
quit;

We can see that proc sql returns a table with a value of 11.

This represents the minimum value in the points column.

Example 2: Find Minimum Value of One Column Grouped by Another Column

The following code shows how to calculate the minimum value in the points column, grouped by the team column in the dataset:

/*calculate minimum value of points grouped by team*/
proc sql;
    select team, min(points)
    from my_data;
    group by team;
quit;

From the output we can see:

• The minimum points value for team A is 11.
• The minimum points value for team B is 14.

Note: You can find the complete documentation for the MIN function in SAS here.

Additional Resources

The following tutorials explain how to perform other common tasks in SAS:

How to Calculate Z-Scores in SAS
How to Use Proc Summary in SAS
How to Calculate Mean, Median, & Mode in SAS