topic All of my data shows up in only one column in SAS Data Management

All of my data shows up in only one column

Tommac72584 — Fri, 24 Jun 2016 15:12:55 GMT

I uploaded this txt file and the output data displays everything in only one column. How do I get it show the data in the seperate columns. Here's the code I used and attached are screenshots.

/* Generated Code (IMPORT) */
/* Source File: hbat tabs.txt */
/* Source Path: /home/tmaciver7840/my_content */
/* Code generated on: Friday, June 24, 2016 3:03:23 PM */

%web_drop_table(WORK.IMPORT3);

FILENAME REFFILE "/home/tmaciver7840/my_content/hbat tabs.txt" TERMSTR=CR;

PROC IMPORT DATAFILE=REFFILE
DBMS=DLM
OUT=WORK.IMPORT3;
GETNAMES=YES;
RUN;

PROC CONTENTS DATA=WORK.IMPORT3; RUN;

%web_open_table(WORK.IMPORT3);

Re: All of my data shows up in only one column

BrunoMueller — Fri, 24 Jun 2016 15:24:35 GMT

From the name of the file and how it behaves, I assume you have a tab delimited file. So your Proc IMPORT code should say DBMS=TAB

proc import
  out=work.book
  datafile="c:\temp\book1_tab.txt"
  dbms=tab
  replace
;
  getnames=yes;
run;

Bruno

Re: All of my data shows up in only one column

Tommac72584 — Fri, 24 Jun 2016 15:30:23 GMT

Yes it is a tab delimited. This fixed it. Thank you Bruno!