. Hi I have 2 tables one has 7k. Records table 2 has 14k
i want to bring every thing from table one 7k records and only the data from table 2 matches...enclose is my code
proc sql;
create table temp2 as
select one.*, two.atm as b_atm, two.date as b_date
from one,two
where one.id=two.id and two.date gt one.date
group by one.id
having two.date-one.date =min(two.date-one.date);
create table want2 as
select temp2.*,two.id as c_id ,two.date as c_date
From temp2,two
where temp2.id =two.id and two.date gt temp2.date
group by temp2.id
having two.date- temp2.date=min(two.date-temp2.date);
quit;
thanks for assistance
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.