how many columns can be imported into SAS

[lulust]

hi !,

I have a text file that has 700 columns, which is very important for my daily work, normally separated into 3 files to finally re-unite in sas, I wonder which is the maximum of columns that can be imported into sas and what version?

thanks for your help!

[SASKiwi]

700 columns should not be a problem for any SAS version. I suspect that your record lengths are likely to be large so you may have to experiment with setting record lengths in SAS.

Are your text file columns delimited or in fixed columns? Does it have a column name header or not?

[lulust]

yes, mi file its delimited by "|" and alll de columns have a name header. thanks for your answer,

how i can check the setting record lengths in SAS?

[SASKiwi]

I would try reading the file as a test, as the SAS log will report on the record length:

data test;

  infile "c:\test.txt" obs = 10;

  input;

  put _infile_;

run;

[lulust]

i will tri, thanks! 😃

[Ksharp]

As I remember rightly, there are not limitation for number of columns . above  9.2

[tomasz]

     There is SAS option LS or LRECL. You can set how many chars read from text file.

[lulust]

thank, exactly what I needed.