topic Re: Using "WITH" in EG in SAS Programming

Using "WITH" in EG

jffeudo86 — Thu, 16 May 2019 15:28:15 GMT

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!

Re: Using "WITH" in EG

Kurt_Bremser — Thu, 16 May 2019 15:40:25 GMT

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

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

Re: Using "WITH" in EG

jffeudo86 — Thu, 16 May 2019 15:57:50 GMT

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

Re: Using "WITH" in EG

Reeza — Thu, 16 May 2019 16:08:57 GMT

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.

Re: Using "WITH" in EG

jffeudo86 — Thu, 16 May 2019 16:15:38 GMT

Thank you @Reeza. That answers my question.