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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.