topic Re: Proc SQL Explicit pass through and Memsize in SAS Programming https://communities.sas.com/t5/SAS-Programming/Proc-SQL-Explicit-pass-through-and-Memsize/m-p/193383#M36364 <HTML><HEAD></HEAD><BODY><P>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).</P><P>IMO memsize will not be a factor for SQL and SQL pass-through. Disk space in the WORK may be the limiting factor.</P></BODY></HTML> Wed, 01 Jul 2015 08:44:33 GMT Kurt_Bremser 2015-07-01T08:44:33Z Proc SQL Explicit pass through and Memsize https://communities.sas.com/t5/SAS-Programming/Proc-SQL-Explicit-pass-through-and-Memsize/m-p/193382#M36363 <HTML><HEAD></HEAD><BODY><P>1. What are the limitations of proc sql explicit pass through?</P><P></P><P>2. How to increase the memory size for current SAS session part from the option 'Memsize'?&nbsp; e.g. I want to generate the billion of records with numerous variables in WORK library without any memory issue.</P></BODY></HTML> Wed, 01 Jul 2015 08:16:11 GMT https://communities.sas.com/t5/SAS-Programming/Proc-SQL-Explicit-pass-through-and-Memsize/m-p/193382#M36363 RamKumar 2015-07-01T08:16:11Z Re: Proc SQL Explicit pass through and Memsize https://communities.sas.com/t5/SAS-Programming/Proc-SQL-Explicit-pass-through-and-Memsize/m-p/193383#M36364 <HTML><HEAD></HEAD><BODY><P>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).</P><P>IMO memsize will not be a factor for SQL and SQL pass-through. Disk space in the WORK may be the limiting factor.</P></BODY></HTML> Wed, 01 Jul 2015 08:44:33 GMT https://communities.sas.com/t5/SAS-Programming/Proc-SQL-Explicit-pass-through-and-Memsize/m-p/193383#M36364 Kurt_Bremser 2015-07-01T08:44:33Z Re: Proc SQL Explicit pass through and Memsize https://communities.sas.com/t5/SAS-Programming/Proc-SQL-Explicit-pass-through-and-Memsize/m-p/193384#M36365 <HTML><HEAD></HEAD><BODY><P>May I request you to elaborate your answers simple terms? Because I couldn't understand <EM>'<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; background-color: #ffffff;">IMO memsize will not be a factor for SQL and SQL pass-through. Disk space in the WORK may be the limiting factor'</SPAN></EM></P></BODY></HTML> Wed, 01 Jul 2015 09:04:16 GMT https://communities.sas.com/t5/SAS-Programming/Proc-SQL-Explicit-pass-through-and-Memsize/m-p/193384#M36365 RamKumar 2015-07-01T09:04:16Z Re: Proc SQL Explicit pass through and Memsize https://communities.sas.com/t5/SAS-Programming/Proc-SQL-Explicit-pass-through-and-Memsize/m-p/193385#M36366 <HTML><HEAD></HEAD><BODY><P>The result back will be&nbsp; a sequential write, which is not a memory intense operation. Test yourself by specifying </P><P><EM>options fullstimer;</EM></P><P>and run your SQL.</P></BODY></HTML> Wed, 01 Jul 2015 10:29:23 GMT https://communities.sas.com/t5/SAS-Programming/Proc-SQL-Explicit-pass-through-and-Memsize/m-p/193385#M36366 LinusH 2015-07-01T10:29:23Z