topic Re: create temporary table in SAS in SAS Programming

create temporary table in SAS

simrut — Wed, 22 Mar 2017 16:24:08 GMT

Hi ,

I am trying to create a temporary table in SAS with below code:

PROC SQL;
CREATE VOLATILE TABLE TEMP AS
(SELECT * FROM SASHELP.AIR)
;
QUIT;

and I m getting the following error

'Syntax error, expecting one of the following: DISTINCT, INDEX, TABLE, UNIQUE, VIEW'

KIndly help.

Re: create temporary table in SAS

LinusH — Wed, 22 Mar 2017 16:27:42 GMT

You are trying to use RDBMS specific syntax.
A temporary table in SAS has the predefined "schema" (libref in SAS terminology) called work.
An equal syntax is to use a one level table specification, work is assumed.

Re: create temporary table in SAS

simrut — Wed, 22 Mar 2017 16:33:25 GMT

Hi LinusH,

Can you clarify more on how can I create a MULSET VOLATILE tabe in SAS?

Re: create temporary table in SAS

Reeza — Wed, 22 Mar 2017 16:37:02 GMT

Check SAS documentation for SQL. There is no VOLATILE in SAS SQL, and not in all SQL implementations either AFAIK.

PROC SQL;
CREATE TABLE TEMP AS
(SELECT * FROM SASHELP.AIR)
;
QUIT;

http://support.sas.com/documentation/cdl/en/sqlproc/69822/HTML/default/viewer.htm#n07kfcv1vbih8rn1k9epo45umxil.htm

Re: create temporary table in SAS

PGStats — Wed, 22 Mar 2017 18:47:24 GMT

PROC SQL;
CREATE TABLE WORK.TEMP AS
SELECT * FROM SASHELP.AIR;
QUIT;

or simply

PROC SQL;
CREATE TABLE TEMP AS
SELECT * FROM SASHELP.AIR;
QUIT;

since WORK is the default library.