Help using Base SAS procedures

how many columns can be imported into SAS

Reply
New Contributor
Posts: 4

how many columns can be imported into SAS

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! Smiley Happy

Super User
Posts: 3,113

Re: how many columns can be imported into SAS

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?

New Contributor
Posts: 4

Re: how many columns can be imported into SAS

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?

Super User
Posts: 3,113

Re: how many columns can be imported into SAS

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;

New Contributor
Posts: 4

Re: how many columns can be imported into SAS

i will tri, thanks! =)

Super User
Posts: 9,687

Re: how many columns can be imported into SAS

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

Frequent Learner
Posts: 1

Re: how many columns can be imported into SAS

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

New Contributor
Posts: 4

Re: how many columns can be imported into SAS

thank, exactly what I needed. Smiley Wink

Ask a Question
Discussion stats
  • 7 replies
  • 462 views
  • 0 likes
  • 4 in conversation