Increasing memory while creating temp table in DB via SAS

[David_Billa]

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;

[LinusH]

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.

[David_Billa]

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

[Kurt_Bremser]

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

[LinusH · Accepted solution]

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...