Simulating a SQL step using SAS

[deleted_user]

How can I simulate this using sas with the least number of steps and preferably using proc sql

WITH TMID_900 (CUR_TM_ID) AS
( SELECT EC900.TM_ID
FROM ru99.test EC900
WHERE ID > 2 AND
ID < 9
)

select * from ru99.salv_item_id, TMID_900 TMID_900 where id = TMID_900.ID ;

This is basically a loop that passes values from the top to be used as input in the where part of the query.

[deleted_user]

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;