Hello All, I am running a query against the database and writing results to a tab-delimited text file. I have data missing for some columns. When I do a proc import, some of the data seems to be contained in one column instead of separate columns. Here is the script I am using below. I have also attached the test file. There are totally 23 columns in the original table. Proc Import Script: LIBNAME vertsas 'test/user'; PROC IMPORT DATAFILE="testFile.txt" OUT=vertsas.testFile DBMS=dlm REPLACE; DELIMITER=’09’x; GETNAMES=yes; RUN; When I generate the sas dataset and open it in Enterprise guide, I see the issue mentioned above Please let me know if this is an encoding issue or a delimiter issue. Thanks!!
... View more