Hi All,
Based on data could anyone assist me - making program that contains
test_date closest to delivery_date.
delivery_date test_date
11/16/2011 21/nov/2011
10/nov/2011
15/oct/2010
Thanks in advance
Hi, I figure you should have an 'id' variable in this case, but if you don't, feel free to take it out:
proc sql;
create table want as
select distinct a.* from have a, have b
where a.id=b.id
group by a.id /*I assume you should have one*/, b.delivery_date
having abs(b.test_date-a.delivery_date)=min(abs(a.delivery_date-b.test_date));
quit;
Haikuo
I have a variable delivery_date with one observation and test_date with 20 observations. I'd like to find the closest date in test_date to delivery_date by find the minimum absolute difference and retain the minimum value.
When I merge the datasets I only get two observations paired up and get missing values for the rest. Would anyone please explain how to go about this with maybe a do loop or...???
Thank you!
delivery_date | ||||||||||||||||||||||
11/16/2011 | ||||||||||||||||||||||
|
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.