Out of memory error while executing a PROC SQL statement

[Saurabh_Rana]

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?

[LinusH]

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.

[ChrisNZ]

@LinusH meant 

msglevel=

not

mesglevel=

[SASKiwi]

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.