An invalid SAS function used in an SQL procedure in a Base SAS® query might end abnormally


If you use an invalid function in Base SAS, the query might abend abnormally rather than issue an error similar to the following:

Function xxxx could not be located.

 

In a UNIX operating environment, an error similar to the following is issued instead:

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:
 
   /install/SASFoundation/9.3/sasexe/sas [0x514ddd]
   /install/SASFoundation/9.3/sasexe/sas [0x41e318]
   /install/SASFoundation/9.3/sasexe/sas [0x41dfef]
   /install/SASFoundation/9.3/sasexe/tkmk.so(bkt_signal_handler+0x144)
   [0x2b6036939364]
   /lib64/libpthread.so.0 [0x35cae0eb70]
   /install/SASFoundation/9.3/sasexe/sassqlu(sqludf+0xc8)
   [0x2aaaba61faa8]
   /install/SASFoundation/9.3/sasexe/sassqlp [0x2aaaba813af6]
   /install/SASFoundation/9.3/sasexe/sassqlp [0x2aaaba8122bc]
   /install/SASFoundation/9.3/sasexe/sassqlp [0x2aaaba811b81]
   /install/SASFoundation/9.3/sasexe/sassqlp(sqltype+0xd5)
   [0x2aaaba80c355]
   /install/SASFoundation/9.3/sasexe/sassqlp(sqlprep+0x18f)
   [0x2aaaba7e508f]
   /install/SASFoundation/9.3/sasexe/sassqx(sqlloop+0xc64)
   [0x2aaaba206af4]
   /install/SASFoundation/9.3/sasexe/sassql(sassql+0x276)
   [0x2aaaba0bae66]
   /install/SASFoundation/9.3/sasexe/sas(vvtentr+0x104) [0x41df34]
   /lib64/libpthread.so.0 [0x35cae0673d]
   /lib64/libc.so.6(clone+0x6d) [0x35ca2d44bd]

 

In Windows operating environments, an error similar to the following is issued instead:

    ERROR:  Read Access Violation In Task [ SQL )
    Exception occurred at (03A6EEC7)
    Task Traceback
    Address   Frame     (DBGHELP API Version 4.0 rev 5)
    03A6EEC7  0784E2B0  sassqlu:mcn_main+0x1DEC7
    053288FF  0784E428  sassqlp:mcn_main+0x478FF
    05324C94  0784E5B0  sassqlp:mcn_main+0x43C94
    0530E5B8  0784E658  sassqlp:mcn_main+0x2D5B8
    03A3381C  0784FF54  sassqx:mcn_main+0x2281C
    600D118A  0784FF88  sassql:mcn_main+0x18A
    01272B02  0784FFA0  sashost:Main+0xBE72
    01276C20  0784FFB4  sashost:Main+0xFF90
    7C80B713  0784FFEC  kernel32:GetModuleFileNameA+0x1B4