Simulating a SQL step using SAS

deleted_user — Fri, 21 Nov 2008 20:29:08 GMT

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.

Re: Simulating a SQL step using SAS

deleted_user — Sat, 22 Nov 2008 03:20:53 GMT

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;

topic Simulating a SQL step using SAS in SAS Procedures

Simulating a SQL step using SAS

Re: Simulating a SQL step using SAS