Suppose there is a list of clients and each client has different contracts that have a due date. For each client, I want to select the contract with the first following duedate after a given reference date.

For example:

Table contracts:

Today we are 2024/08/19, so I would want to select for each client 1 contract that will be due firstly after today.
So what I want is

What i would like to do is

proc sql;
create table DueContracts as (
select Client
       , contract 
from contracts
where due_date = min (due dates that are larger than *reference date*)
)
;quit;

The where clause is obviously pseude code, I don’t know how to do this. I can do it for one seperate clients, but I don’t know how to do it for all clients at once.