DATA Step, Macro, Functions and more

Proc SQL Explicit pass through and Memsize

Reply
Regular Contributor
Posts: 168

Proc SQL Explicit pass through and Memsize

1. What are the limitations of proc sql explicit pass through?

2. How to increase the memory size for current SAS session part from the option 'Memsize'?  e.g. I want to generate the billion of records with numerous variables in WORK library without any memory issue.

Super User
Posts: 7,758

Re: Proc SQL Explicit pass through and Memsize

You cannot change the memsize for a running session. Memsize (and other memory-related parameters) is set at SAS invocation only (from commandline or config file).

IMO memsize will not be a factor for SQL and SQL pass-through. Disk space in the WORK may be the limiting factor.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Regular Contributor
Posts: 168

Re: Proc SQL Explicit pass through and Memsize

Posted in reply to KurtBremser

May I request you to elaborate your answers simple terms? Because I couldn't understand 'IMO memsize will not be a factor for SQL and SQL pass-through. Disk space in the WORK may be the limiting factor'

Super User
Posts: 5,424

Re: Proc SQL Explicit pass through and Memsize

The result back will be  a sequential write, which is not a memory intense operation. Test yourself by specifying

options fullstimer;

and run your SQL.

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 276 views
  • 0 likes
  • 3 in conversation