SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
podarum
Quartz | Level 8

Hi, what is the best way to check what the latest dates are in 3 differet tables from one procedure?  The vriable 'Process_Date' is called the same in all 3 tables, however there are no linkage between the 3 tables.. like acct. number.  Also is there a way to see the same ask, but if the term 'process_Date' is called different for all 3 tables?  Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User
data want (keep=max_date);
set
  table1
  table2
  table3
  end=done
;
retain max_date;
format max_date date9.;
max_date = max(max_date,process_date);
if done
then do;
  call symput('max_date',put(max_date,best.));
  output;
end;
run;

gives you both a dataset and a macro variable for further use.

View solution in original post

3 REPLIES 3
Reeza
Super User

What are you expecting for output? 3 diff dates, highest from each?

One date that's highest from all three tables? 

Kurt_Bremser
Super User
data want (keep=max_date);
set
  table1
  table2
  table3
  end=done
;
retain max_date;
format max_date date9.;
max_date = max(max_date,process_date);
if done
then do;
  call symput('max_date',put(max_date,best.));
  output;
end;
run;

gives you both a dataset and a macro variable for further use.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 998 views
  • 0 likes
  • 3 in conversation