topic how many columns can be imported into SAS in SAS Procedures

how many columns can be imported into SAS

lulust — Thu, 09 Oct 2014 22:33:32 GMT

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!

Re: how many columns can be imported into SAS

SASKiwi — Fri, 10 Oct 2014 02:40:42 GMT

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?

Re: how many columns can be imported into SAS

lulust — Mon, 13 Oct 2014 14:48:31 GMT

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?

Re: how many columns can be imported into SAS

SASKiwi — Mon, 13 Oct 2014 18:35:25 GMT

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;

Re: how many columns can be imported into SAS

Ksharp — Tue, 14 Oct 2014 13:09:38 GMT

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

Re: how many columns can be imported into SAS

tomasz — Tue, 14 Oct 2014 19:46:45 GMT

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

Re: how many columns can be imported into SAS

lulust — Tue, 14 Oct 2014 20:00:41 GMT

i will tri, thanks! 😃

Re: how many columns can be imported into SAS

lulust — Tue, 14 Oct 2014 20:03:16 GMT

thank, exactly what I needed.