Date:         Fri, 7 Aug 2009 08:09:55 -0700
Reply-To:     "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject:      Re: changing the maximum record length from 256
Comments: To: wes <w.greenhead@GOOGLEMAIL.COM>
In-Reply-To:  A<7733a000-833e-4ea2-bb95-02be4a3aaa93@q14g2000vbi.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

Hi Wes,


 infile '\\Icna4\clients\TP\02.txt' lrecl=541;


Use LRECL to get beyond 256, it handles fixed
lengths.  If your file has line terminations
then you will need to augment with one of a
couple different sets of flags to accomodate.


Hope this is helpful.


Mark Terjeson
Investment Business Intelligence
Investment Management & Research
Russell Investments
253-439-2367


Russell
Global Leaders in Multi-Manager Investing





-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of wes
Sent: Friday, August 07, 2009 7:25 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: changing the maximum record length from 256

hi,

im trying to import a fixed width file of 541 characters long using
this code below:

data test;
 infile '\\Icna4\clients\TP\02.txt';
 input field1 $ 1-2 field2 $ 3-9 field3 $ 10-13 field4 $ 14-54 field5
$ 55-95
field14 $96-136 field15 $ 137-177 field16 $ 178-218 field9 $ 219-259
field10 $ 260-265
field11 $ 266-303 field12 $ 304-304 field13 $ 305-541;
run;

However its giving me a message about maximum record length being 256,
how do i change this?

Many thanks for your help

Wes