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 | ||||||||||||||||||||||
|
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.