topic Re: Error due to Exceeding Length in SAS Programming

Error due to Exceeding Length

newbie_ari — Wed, 23 Jan 2013 04:39:19 GMT

Hi,

I'm getting this following error:

ERROR: The text expression length (65538) exceeds maximum length (65534). The text expression has been truncated to 65534

characters.

Is there any way to exceed this limitations?

Regards,

Newbie

Re: Error due to Exceeding Length

Jagadishkatam — Wed, 23 Jan 2013 06:00:48 GMT

could you show us the code you have used and it resulted in this error.

Thanks,

Jagadish

Re: Error due to Exceeding Length

newbie_ari — Wed, 23 Jan 2013 08:46:33 GMT

Hi Jagadish,

Thanks for your reply. It's unfortunate that I can't share my code. That's why I put that brief question. We are actually running models & pass variables through a macro. Now this macro's length is becoming greater than 65534. The modelling code is pretty complicated. So, it's pretty cumbersome to create 2 or more parts of the variables. So, I was wondering if SAS has some option where I can relax the length limit.

Regards

Re: Error due to Exceeding Length

kuridisanjeev — Wed, 23 Jan 2013 08:53:15 GMT

Hi..

I don't think there is a option available to increase macro variable length.You may need to work out on your code to divide your macro variable into two parts.

Go through bellow link for more info..

Thanks&Regards.

Sanjeev.K

Re: Error due to Exceeding Length

Jagadishkatam — Wed, 23 Jan 2013 09:06:01 GMT

Hi,

as per my understanding that error happens when you have missed to place a semicolon at the end of the value within a macro variable like example

%let string=abc

and if you have used %str() without any blank space within the (). it should be changed to %str( ). give atleast a single space within the ( ).

Hope this helps you.

Thanks,

Jagadish

Re: Error due to Exceeding Length

newbie_ari — Wed, 23 Jan 2013 09:39:11 GMT

Thanks Sanjeev! I was just bit optimistic...in case! I'll update the code to have multiple macro options.

Re: Error due to Exceeding Length

claudiajc — Fri, 02 Dec 2016 20:09:31 GMT

I came here with the same isue. One of the existing answers suggested I should review carefully my code again. I found a missing closing parenthesis was causing the error. The missing parenthesis made the code look something like this:

%macro a (var1,var2;

The right code should have been:

%macro a (var1,var2);