topic Re: Using "WITH" in EG in SAS Enterprise Guide

Using "WITH" in EG

jffeudo86 — Thu, 16 May 2019 15:29:14 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

tsap — Thu, 16 May 2019 15:39:15 GMT

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.

Re: Using "WITH" in EG

jffeudo86 — Thu, 16 May 2019 15:56:08 GMT

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

Re: Using "WITH" in EG

jffeudo86 — Thu, 16 May 2019 16:18:07 GMT

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

Re: Using "WITH" in EG

tsap — Thu, 16 May 2019 16:37:23 GMT

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.

Re: Using "WITH" in EG

jffeudo86 — Thu, 16 May 2019 18:59:44 GMT

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

Thank you!