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.
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.