Help using Base SAS procedures

get the min or max date in a dataset

Reply
Occasional Contributor
Posts: 7

get the min or max date in a dataset

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

Regular Contributor
Posts: 229

get the min or max date in a dataset

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.

Occasional Contributor
Posts: 7

get the min or max date in a dataset

Hello R_Win

Many thanks for this solution which helps me very much

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

Thanks again

Joël

Ask a Question
Discussion stats
  • 2 replies
  • 3093 views
  • 0 likes
  • 2 in conversation