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!
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?
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?
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;
i will tri, thanks! 😃
As I remember rightly, there are not limitation for number of columns . above 9.2
There is SAS option LS or LRECL. You can set how many chars read from text file.
thank, exactly what I needed.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.