Using "WITH" in EG

[jffeudo86]

Hi,

How can I use a WITH statement in SAS, or is it possible?  Code below returns "Statement is not valid or it is used out of proper order." highlighting the "WITH" .  What do I need to do if it's possible?  Or is it just an Oracle statement?

WITH test
AS (SELECT * FROM xx (OBS=10))
SELECT test.*;

Thanks!

[jffeudo86]

How can I use a WITH statement in SAS, or is it possible?  Code below returns "Statement is not valid or it is used out of proper order." highlighting the "WITH" .  What do I need to do if it's possible?  Or is it just an Oracle statement?

WITH test
AS (SELECT * FROM xx (OBS=10))
SELECT test.*;

Thanks!

[Kurt_Bremser]

Should that retrieve just 10 obs from xx? If yes, then it's just

data test;
set xx (obs=10);
run;

[jffeudo86]

Thank you Kurt! I'm interested in the use of "WITH". I guess it's an Oracle statement then and not SAS statement.

[Reeza · Accepted solution]

PROC SQL doesn't support a WITH statement. If you're using SQL pass through you can use Oracle SQL. Depends on your set up and access permissions.

[jffeudo86]

Thank you @Reeza. That answers my question.