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!

[tsap]

That logic will not work as it is written currently when attempted in SAS.

The logic in SAS will need to look like this:

PROC SQL;
CREATE TABLE Test AS
	(SELECT * from InsertTableName (obs=10));
QUIT;

Hope this helps.

[jffeudo86]

Thank you for your reply @tsap. I'm interested in using "WITH", not creating a table.

[jffeudo86 · Accepted solution]

A solution has been accepted. Thank you all.
https://communities.sas.com/t5/SAS-Programming/Using-quot-WITH-quot-in-EG/m-p/559393#M156191

[tsap]

I guess my question is the function of the 'WITH' that you are interested in using. If your intention is printing the 10 observations from that table and not creating a table, then you would make a small modification to the SQL logic I supplied earlier.

PROC SQL;
	(SELECT * from InsertTableName (obs=10));
QUIT;

This will not create a table. It will just print the details from 10 observations on the table specified.

[jffeudo86]

Sorry if my question was not clear. A solution has been accepted and a link was posted.

Thank you!