Reading large ASCII file

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Reading large ASCII file

Sophia Huang
Hi,

I have an ASCII file that contains over 12,000 columns/characters. Is
there a way to write a syntax that reads all columns?

Thank you very much

Sophia
Reply | Threaded
Open this post in threaded view
|

Re: Reading large ASCII file

Simon Phillip Freidin
use 'file handle' to locate the file and allow it to exceed the
default record length by using the /lrecl=13000
option

file handle name=indata/file='c:\temp\newdata.dat'/lrecl=13000.

you do need to say either which columns each variable is in (unless
the data is delimited) using the data list or get data commands. For
example, this will read each column into a numeric variable:

data list file=indata fixed/n1 to n13000 (13000f1).

Post another query about reading the data if there are text variables
or multi-column variables, or if the file is comma-delimited.

cheers
Simon

On 01/06/2007, at 3:44 AM, Sophia Huang wrote:

> Hi,
>
> I have an ASCII file that contains over 12,000 columns/characters. Is
> there a way to write a syntax that reads all columns?
>
> Thank you very much
>
> Sophia