Import .txt tab delimited file

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

Import .txt tab delimited file

[ Edited ]

 

 

 

I am having trouble importing the data sets to my SAS program.  The data set is not been displayed correctly.

 

 

DATA ob1;
INFILE "/folders/myfolders/Study.txt" DLM='05'x FIRSTOBS=2 DSD;
INPUT Poverty Growth;
RUN;

PROC PRINT DATA=ob1;
RUN;


Accepted Solutions
Solution
‎02-21-2018 02:03 PM
Super User
Super User
Posts: 8,069

Re: Import .txt tab delimited file

Looks like your program is assuming that data is using EBCDIC tab character '05'x, but the actual data files are using ASCII tab character '09'x.

View solution in original post


All Replies
Solution
‎02-21-2018 02:03 PM
Super User
Super User
Posts: 8,069

Re: Import .txt tab delimited file

Looks like your program is assuming that data is using EBCDIC tab character '05'x, but the actual data files are using ASCII tab character '09'x.

Contributor
Posts: 22

Re: Import .txt tab delimited file

You are right! Thanks!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 113 views
  • 1 like
  • 2 in conversation