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.
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;
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?
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;
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!
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.
Ready to level-up your skills? Choose your own adventure.