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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.