Creating temporary/Session specific tables in SingleStore

niyatisheth — Mon, 23 Feb 2026 10:57:54 GMT

Hello ! We are exploring using SingleStore/SpeedyStore in our product solution based on SAS Viya. We plan to use SAS/Access libname to connect to the SingleStore database.

The question is how do I create a temporary/session specific table (so that it is seen and read only in that session ) within singlestore so that there is no data movement.

libname y s2 user=<user> server=<server> database=<db> port=<port>;

if I create a table using y as the libref , the below code creates a permanent table.

data y.temp;

set y.cars;

run;

My aim is to create and work on a series of temporary tables using data steps and proc sqls till I achieve my final output table.

Thanks for helping.

Re: Creating temporary/Session specific tables in SingleStore

LinusH — Tue, 24 Feb 2026 15:12:22 GMT

Try the DBMSTEMP= libname option:

https://documentation.sas.com/doc/da/pgmsascdc/v_065/acreldb/p0he4t6yjfmkhpn16qrf0cdhllu6.htm

topic Re: Creating temporary/Session specific tables in SingleStore in SAS Viya

Creating temporary/Session specific tables in SingleStore

Re: Creating temporary/Session specific tables in SingleStore