Finding closest value

[art297]

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

[chintanpatel]

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

[art297 · Accepted solution]

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

[chintanpatel]

Hello sir,

                Thank you very much for your help. It is all working now.