topic get the min or max date in a dataset in SAS Procedures

get the min or max date in a dataset

joel — Thu, 15 Dec 2011 10:10:21 GMT

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

get the min or max date in a dataset

R_Win — Thu, 15 Dec 2011 10:31:18 GMT

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.

get the min or max date in a dataset

joel — Thu, 15 Dec 2011 11:52:16 GMT

Hello R_Win

Many thanks for this solution which helps me very much

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

Thanks again

Joël