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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.