BookmarkSubscribeRSS Feed
Crt
Fluorite | Level 6 Crt
Fluorite | Level 6

Hello everyone!

 

I am trying to assign many characters to a string in DataFlux using Expression Language.

 

What I have done is:

string(100000) myStr

 

If I increase the number of characters from 100.000 to 1.000.000, it does not work even though the expression is valid.

 

Is there any way to assign many characters (greater than 100.000) to a string using Expression Language?

 

Thank you in advance.

 

 

2 REPLIES 2
audrey
SAS Employee

Hello,

 

I think the EEL language limits strings to 64KB by default.
There might be a way to get around this limitation by adding this line in app.cfg:

 

EXPRESS_MAX_STRING_LENGTH = 1000000

 

Can you try this?

 

Audrey

www.sas.comsupport.sas.com
SAS®... THE POWER TO KNOW®
Crt
Fluorite | Level 6 Crt
Fluorite | Level 6

Hi! Thank you very much for your response.

 

I added your code line in app.cfg of both DataFlux Data Management Studio and DataFlux Data Management Server and it didn't change anything. Should I do something more in app.cfg or in DataFlux?

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 549 views
  • 0 likes
  • 2 in conversation