topic Import .txt tab delimited file in SAS Programming

Import .txt tab delimited file

Miah — Thu, 22 Feb 2018 02:06:05 GMT

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;

Tom — Wed, 21 Feb 2018 18:53:33 GMT

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.

Miah — Wed, 21 Feb 2018 19:03:49 GMT

You are right! Thanks!