Date:         Wed, 29 Jul 2009 13:21:37 -0400
Reply-To:     Mike Rhoads <RHOADSM1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mike Rhoads <RHOADSM1@WESTAT.COM>
Subject:      Re: SASware Ballot - Change LRECL
Comments: To: Randy Herbison <RandyHerbison@WESTAT.com>
In-Reply-To:  <A8625BEB312CB2469E61B5E17F59B949081C51DA@EX-CMS01.westat.com>
Content-Type: text/plain; charset="us-ascii"

I guess the next best thing would be to save the generated code, rather than running it immediately, and make the change to the LRECL before submitting the program.  I believe there's an option in the EFI to do this, but haven't tried it lately.

Mike Rhoads
RhoadsM1@Westat.com


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Randy Herbison
Sent: Wednesday, July 29, 2009 1:09 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: SASware Ballot - Change LRECL


Good idea, but PROC EXPORT (using the EFI) seems to have a mind of its own:

262318  filename csv "C:\TEMP\test.csv"  lrecl=50000;
262319
262320  PROC EXPORT DATA= WORK.TEST
262321              OUTFILE= csv
262322              DBMS=CSV REPLACE;
262323       PUTNAMES=YES;
262324  RUN;

262325   /**********************************************************************
262326   *   PRODUCT:   SAS
262327   *   VERSION:   9.2
262328   *   CREATOR:   External File Interface
262329   *   DATE:      29JUL09
262330   *   DESC:      Generated SAS Datastep Code
262331   *   TEMPLATE SOURCE:  (None Specified.)
262332   ***********************************************************************/
262333      data _null_;
262334      %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
262335      %let _EFIREC_ = 0;     /* clear export record count macro variable */
262336      file CSV delimiter=',' DSD DROPOVER lrecl=32767;

Too bad SAS doesn't include the SCL source code.  If it did, we could modify it.

-Randy



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of data _null_
Sent: Wednesday, July 29, 2009 11:08 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: SASware Ballot - Change LRECL

On Jul 29, 9:30 am, My <my0...@gmail.com> wrote:
> How does one add an item to the SASware Ballot? A collegue of mine
> wants an lrecl parameter to be added to proc export for csv so he can
> change to lrecl to the max of 1048576 from the default 32767. In the
> mean time, if anyone has a solution for his needs, it would be greatly
> appreciated.
>
> Thanks.
> Myra

Use a FILEREF for the OUTFILE parameter...

filename FT42F001 'TESTLRECL.CSV' lrecl=1048576;
proc export outfile=FT42F001 dbms=csv data=sashelp.class;
   run;