Segmentation violation error

[Sathya3]

I am working on a large data  where I am creating 150+ columns using case statements in proc sql create table with multiple join conditions

When I try to run the code and create output it is giving me error for few tables where the record count is around 20 millions in source table .It is running fine for other tables where record count is less in source tables.

I am not creating any sas view. I am creating tables in hive using proc sql sas code. I have done some research over the net about this error and my code is not falling into any categories where this error can occur as per sas support portal

Can someone pls help resolve this.Below is the error

ERROR:  An exception has been encountered.
Please contact technical support and provide them with the following traceback information:

The SAS task name is [SQL     ]
Segmentation Violation

Traceback of the Exception:

/home/sas/sas94m6/SASFoundation/9.4/sasexe/sas(+0x16844e) [0x7f68ffaf444e]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sas(+0x4ee1f) [0x7f68ff9dae1f]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x7f68fddcdac4]
/lib64/libpthread.so.0(+0x3d36c0f790) [0x7f68ff33e790]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x23eff) [0x7f68c6175eff]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x22ac3) [0x7f68c6174ac3]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x2f9d8) [0x7f68c61819d8]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(+0x391a1) [0x7f68c618b1a1]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlu(sqltxt2+0x51e) [0x7f68c616711e]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(+0x5089d) [0x7f68c640d89d]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(sqlpsel+0xfb6) [0x7f68c640c5f6]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(sqlplan+0x219) [0x7f68c63f8de9]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqlp(sqlprep+0x3ee) [0x7f68c642a89e]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqx(+0x3be91) [0x7f68c6dc4e91]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassqx(sqlloop+0x417) [0x7f68c6dc4617]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sassql(sassql+0x362) [0x7f68c7416402]
/home/sas/sas94m6/SASFoundation/9.4/sasexe/sas(vvtentr+0x18a) [0x7f68ff9da97a]
/lib64/libpthread.so.0(+0x3d36c07a51) [0x7f68ff336a51]
/lib64/libc.so.6(clone+0x6d) [0x7f68fe9c496d]

[PaigeMiller]

ERROR:  An exception has been encountered.
Please contact technical support and provide them with the following traceback information:

Contact SAS Technical Support.

[SASKiwi]

What is your SAS session MEMSIZE setting? Normally PROC SQL will error gracefully if it runs out of memory, but it is possible if it has way too little memory it may not behave gracefully. Run this to confirm your MEMSIZE and post the results:

proc options option = memsize;
run;

 In my experience, large SQL queries require a MEMSIZE of at least 6GB.

[ChrisNZ]

To note that MEMSIZE is for memory including paging space. REALMEMSIZE is for RAM only.