proc sql;
create table want as
select a.father_mean1
from dataset1 a, dataset2 b
having abs(a.father_mean1-b.father_mean1) eq min(abs(a.father_mean1-b.father_mean1))
;
quit;
Art, CEO, AnalystFinder.com
It gave me the closest value.
but in output it gave me only
father_mean
69.173300123
And i have to use value of _imp_ for the next steps.
so in the output i need
_imp_ father_mean
51 69.173300123
proc sql; create table want as select a._imp_,a.father_mean1 from dataset1 a, dataset2 b having abs(a.father_mean1-b.father_mean1) eq min(abs(a.father_mean1-b.father_mean1)) ; quit;
That will add _imp_ as well,
Art, CEO, AnalystFinder.com
Hello sir,
Thank you very much for your help. It is all working now.
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.