topic Re: find largest value of a column from 2 dataset in SAS Programming

find largest value of a column from 2 dataset

adi121 — Fri, 21 Aug 2020 05:31:43 GMT

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.

Re: find largest value of a column from 2 dataset

ballardw — Fri, 21 Aug 2020 06:03:26 GMT

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?

Re: find largest value of a column from 2 dataset

PeterClemmensen — Fri, 21 Aug 2020 06:05:10 GMT

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;