SAS proc sql: select for each value the right interval

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.

You are very close. You need to do pre-processing with where and post-processing with having. Think of it in two steps:

1. Get all due dates that are > the reference date (19AUG2024)
2. For each of those clients with due dates > 19AUG2024, filter to the date that is equal to the minimum of those dates

Here's how that looks:

proc sql;
    create table DueContracts as
        select Client, Contract 
        from contracts
        where due_date > '19AUG2024'd
        group by client
        having due_date = min(due_date)
    ;
quit;

Client  Contract
Anthony Contract A3
Bart    Contract B3
Carla   Contract C2