BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
adi121
Fluorite | Level 6

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.

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

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;

View solution in original post

2 REPLIES 2
ballardw
Super User

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
Tourmaline | Level 20

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;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 2 replies
  • 808 views
  • 0 likes
  • 3 in conversation