topic Re: Increasing memory while creating temp table in DB via SAS in SAS Programming

Increasing memory while creating temp table in DB via SAS

David_Billa — Fri, 28 May 2021 05:38:20 GMT

Is there a way to increase the memory with some SAS Options while creating the temp table in SQL Server database with the following code. There are millions of records in CUSTOMER table and I don't want to see any shortage of memory issue in future.

Proc Sql;
                Create table _etltmp."##temp_input_&unique_num."n as 
                    Select * from CUSTOMER;
            quit;

Re: Increasing memory while creating temp table in DB via SAS

LinusH — Fri, 28 May 2021 05:57:23 GMT

Are you referring to SQL Server table space?

I think you configure that on database level, and there's options to have it automatically grow.

I can't see that there should be any memory issues on the SAS side (RAM?)

If you are concerned about disk on SAS side, make sure you have enough space in your saswork location.

Re: Increasing memory while creating temp table in DB via SAS

David_Billa — Fri, 28 May 2021 06:41:24 GMT

@LinusH yes, I'm referring to SQL Server table space. May I know the Options to SQL Server table space?

Re: Increasing memory while creating temp table in DB via SAS

Kurt_Bremser — Fri, 28 May 2021 06:55:51 GMT

Talk to your SQL Server admins. You, as an "end user", cannot manipulate such parameters.

Re: Increasing memory while creating temp table in DB via SAS

LinusH — Fri, 28 May 2021 08:54:14 GMT

While talking to you SQL Server admins, you can use the terms FILEGROWTH and AUTOGROW.

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-file-and-filegroup-options?view=sql-server-ver15