topic Re: maximum line length of 254 characters in expression builder in SAS Procedures

maximum line length of 254 characters in expression builder

deleted_user — Tue, 13 Jan 2009 18:18:51 GMT

Hi SAS,
Is there any hot fix or something wrong I am facing this issue in DI studio3.4

"The line exceeds the maximum line length of 254 characters in expression builder"

Thanks,

Re: maximum line length of 254 characters in expression builder

Doc_Duke — Tue, 13 Jan 2009 19:32:46 GMT

Yes, and no. Check this SAS note for ideas.

http://support.sas.com/kb/16/461.html

(I'm not a DI user, so I don't know it's specific constraints, but if it builds SAS code, the ideas referenced may work.)

Doc Muhlbaier
Duke

Re: maximum line length of 254 characters in expression builder

deleted_user — Wed, 14 Jan 2009 04:43:32 GMT

I think you misunderstood my question :

I am not able to write more than 254 characters in Expression window provided in SAS DI 3.4? its impacting my work.

Thanks,

Re: maximum line length of 254 characters in expression builder

Patrick — Wed, 14 Jan 2009 10:18:19 GMT

I couldn't find another note than the one Duke already mentioned.

Did you read that?
"One workaround for this problem is to define the entire expression as a
macro earlier in your job definition, then invoke this macro in the
Expression Builder window."

Not that this is pretty but: You could assign the whole expression to a macro var in the pre-processing part of your job and then just call this macro var in the expression builder window (I think that's under advanced where you can write your own expression - click, click...)

You have always the possibility to open a support track with our friends from SAS Tech Support: http://support.sas.com/ctx/supportform/index.jsp

HTH
Patrick

Re: maximum line length of 254 characters in expression builder

LinusH — Wed, 14 Jan 2009 10:51:46 GMT

I have no problem adding long expressions, as long as I use carriage returns in my code.

/Linus

Re: maximum line length of 254 characters in expression builder

Patrick — Wed, 14 Jan 2009 22:56:52 GMT

I investigated a bit more:
DI doesn't let you save too long lines (>254) as such lines would get truncated in SAS batch processing.
Linus got it once more right: Just add line breaks and everything will work fine.

Patrick