Help using Base SAS procedures

Simulating a SQL step using SAS

Reply
N/A
Posts: 0

Simulating a SQL step using SAS

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.
N/A
Posts: 0

Re: Simulating a SQL step using SAS

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;
Ask a Question
Discussion stats
  • 1 reply
  • 95 views
  • 0 likes
  • 1 in conversation