topic Re: Import txt data with tab-delimited values in SAS Procedures

Import txt data with tab-delimited values

Dingdang — Thu, 07 Nov 2013 15:56:59 GMT

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

Re: Import txt data with tab-delimited values

brsinco — Thu, 07 Nov 2013 16:17:57 GMT

Hi Dingdang,

Try delimiter=tab.

Hope this helps.

Brandy

Re: Import txt data with tab-delimited values

Dingdang — Thu, 07 Nov 2013 16:25:57 GMT

hi Brandy,

thanks for your quick help. just tried it but still i got the same error message error 180

BR Dingdang

Re: Import txt data with tab-delimited values

AJPeters — Thu, 07 Nov 2013 17:03:20 GMT

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;

Re: Import txt data with tab-delimited values

Dingdang — Fri, 08 Nov 2013 07:24:09 GMT

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.