find largest value of a column from 2 dataset

[adi121]

I have 2 datasets - grpA and grpb having id and salary.

I want to compare and output the largest salary from 2 dataset.

proc compare
base = sashelp.grpa
compare = sashelp.grpb;
var salary;
run;

By proc compare we can only compare

Let  me know is there any way to output the largest value.

[ballardw]

What exactly do you want the output to look like? A data set? A report for people to read?

Only one variable, all numeric variables or some other combination?

[PeterClemmensen · Accepted solution]

I'm just guessing the form of output here

data grpa;
input id salary;
datalines;
1 100
2 300
3 200
;

data grpb;
input id salary;
datalines;
4 600
5 500
6 400
;

proc sql;
   select * from 
   (select * from grpa
   union
   select * from grpb)
   having max(salary)=salary;
quit;