topic Re: Out of memory error while executing a PROC SQL statement in SAS Programming

Out of memory error while executing a PROC SQL statement

Saurabh_Rana — Thu, 15 Oct 2020 08:20:38 GMT

While executing a PROC SQL statement on a big data file I am getting this error - "ERROR: Out of memory while converting blob to table"

How to resolve this issue?

Re: Out of memory error while executing a PROC SQL statement

LinusH — Fri, 16 Oct 2020 06:13:39 GMT

The message make think that you are using PROC SQL towards an ACCESS libref.

Add

options msglevel=i sastrace=',,,d' sastraceloc=saslog nostsuffix fullstimer;

and share the log.

Potentially try the operation with a smaller input with above options to learn how the environment behaves.

Re: Out of memory error while executing a PROC SQL statement

SASKiwi — Thu, 15 Oct 2020 20:23:02 GMT

What version of SAS are you using? If its SAS 9.4, blobs have to be cast as character variables and the variable size limit is 32K. Viya has higher limits I understand.

Re: Out of memory error while executing a PROC SQL statement

ChrisNZ — Fri, 16 Oct 2020 01:12:46 GMT

@LinusH meant

msglevel=

not

mesglevel=