Hi,
I know there are already a lot of old posts to this question. I read them through but I still cannot solve my problem.
I have an excel table with more than 255 columns. that is why i saved the excel data to a .txt data with tab-delimited values. and then i used the following code to read it into SAS:
PROC IMPORT OUT=libl.texttest
DATAFILE="R:\Test\myfile.txt";
DBMS=DLM REPLACE;
GETNAMES=YES;
DELIMITER='09'x;
SCANTEXT=YES;
RUN;
when i look at the log, it shows error 180-322.
can someone help me solve this problem or give me a hint, how it came out like this? I am very grateful for that.
BR Dingdang
It looks like you've got an extra semi-colon in the import, after the datafile spec.
PROC IMPORT OUT=libl.texttest
DATAFILE="R:\Test\myfile.txt"; * <~~~ Remove this semi-colon;
DBMS=DLM REPLACE;
GETNAMES=YES;
DELIMITER='09'x;
SCANTEXT=YES;
RUN;
Hi Dingdang,
Try delimiter=tab.
Hope this helps.
Brandy
hi Brandy,
thanks for your quick help. just tried it but still i got the same error message error 180
BR Dingdang
It looks like you've got an extra semi-colon in the import, after the datafile spec.
PROC IMPORT OUT=libl.texttest
DATAFILE="R:\Test\myfile.txt"; * <~~~ Remove this semi-colon;
DBMS=DLM REPLACE;
GETNAMES=YES;
DELIMITER='09'x;
SCANTEXT=YES;
RUN;
hi AJPeters,
thanks, that was one of the errors that i made. In addition i deleted the row "SCANTEXT=YES" and then it worked well.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.