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
Hi LinusH,
Can you clarify more on how can I create a MULSET VOLATILE tabe in SAS?
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;
Do
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.