Maybe this:
proc sql;
select * from ru99.salv_item_id,
(SELECT EC900.TM_ID
FROM ru99.test EC900
WHERE ID > 2 AND
ID < 9) TMID_900
where id=tmid_900.id;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.