Date:         Tue, 24 Feb 2009 10:43:05 +0800
Reply-To:     "Yuntao_Dou (BJ)" <Yuntao_Dou@SMICS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Yuntao_Dou (BJ)" <Yuntao_Dou@SMICS.COM>
Subject:      =?GB2312?Q?=B4=F0=B8=B4:?= SAS code line maximum length 960
In-Reply-To:  A<gnvif3$b72$1@news.motzarella.org>
Content-Type: text/plain; charset="GB2312"

Firstly, we had better avoid to have one line that is greater than 960 chars longs for it is not a bood programming habit
Secondly, we can use program editor instead of enhanced one to bypass the issue.

Best Regards

Yuntao Dou/21515
Northern Product/BJ YMS
Semiconductor Manufacturing International corporation(Beijing)
中芯国际集成电路制造（北京）有限公司
No.18 Wenchang Road,Beijing Developing Area,Beijing China.
中国北京市亦庄经济技术开发区文昌大道18号(100176)
E-mail: yuntao_dou@smics.com
telephone:010-67855000-21515

-----原始邮件-----
发件人: SAS(r) Discussion [mailto:SAS-L@LISTSERV.VT.EDU]代表 Lou
发送时间: 2009年2月24日 9:29
收件人: SAS-L@LISTSERV.VT.EDU
主题: Re: SAS code line maximum length 960


"Kenneth M. Lin" <kenneth_m_lin@sbcglobal.net> wrote in message
news:1EEol.17586$yr3.11899@nlpi068.nbdc.sbc.com...
> Wouldn't it be easier to break down your SQL code into several
chunks/steps
> instead of waiting around for a response?  You didn't provide your code
but
> I am suspecting that you are listing a lot of variables names.

It doesn't matter how many variable names are being used, what matters is
that whatever it is is strung out on one (1) line that's greater than 960
characters long.

No matter how you slice it, that's not a great way to write code - by the
time you've scrolled that far to the right, you can't see what's back there
in the beginning of the line on the left.

Instead of writing:

proc sql; create table fee as select fie, fo, fum from ismell order by the,
blood, of, an, englishman; quit;

write your code as

proc sql;
   create table fee as
      select fie, fo fum
      from ismell
      order by the, blood, of, an, englishman;
quit;

>
> "Zibiao Zhang" <HSPH.HARVARD.EDU> wrote in message
> news:49A2C484.1391.00DD.0@hsph.harvard.edu...
> > Hi All,
> >
> > I wrote a proc sql sas code which is longer than 960 characters, then
sas
> > said:
> >
> > submitted code contains lines longer than 960 characters, SAS is unable
to
> > process lines longer than 960 characters. Your submission has been
> > aborted.
> >
> > Any idea I can reset this option?
> >
> > Thanks,
> > Z
>
>