get the min or max date in a dataset

[joel]

Hello

I use a dataset containing dates

I would like to append new dates from another file but surely not add yet existing dates

So I would like to filter dates from new file considering the greatest date in my base dataset

something like : where date ge max date of base dateset !

Many thanks in advance 🙂

Joël

[R_Win]

1.First load your new file to a dataset 2.proc sql;   select max(date) into :max_date from old_table;   quit; 3. Now you can filter the date if the date is greater than the macro variable:max_date 4.you can append to the existing dataset.

[joel]

Hello R_Win

Many thanks for this solution which helps me very much

Simple, concise, fast, in a word : efficient !

Thanks again

Joël