How to read textfile that contain data with " (Double quote) and keep in dataset

Ani_Abby — Tue, 12 Jun 2018 01:50:11 GMT

Hi,

I have a problem when I import dataset from textfile where some of the data has double quote but when I import the double quote goes missing. Example below is sample of my textfile

Cust_ID|Name|Customer_Status

1|ABC|Active

2|"Def"|Inactive

3|FGH IKL|Active

4|KL, MNO|Terminate

5|PQ-RS TU|Close

This is my coding

DATA WORK.CUSTOMER (COMPRESS=BINARY);
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
infile '/s1/text/extracted/customer_list.txt'
delimiter = '|'
TRUNCOVER DSD lrecl=32767 firstobs=2 recfm=D;

LENGTH

CUST_ID 8

CUST_NAME $40.

CUST_STATUS $20.

;

FORMAT

CUST_ID BEST32.

;

INPUT

CUST_ID

CUST_NAME $

CUST_STATUS $

;

RUN;

Once run, the output only display as below

Cust_ID	Cust_Name	Cust_Status
1	ABC	Active
2	Def	Inactive
3	FGH IKL	Active
4	KL, MNO	Terminate
5	PQ-RS TU	Close

The main problem is the double quote is missing once I run this code. Is there any setting when using infile command?

Re: How to read textfile that contain data with " (Double quote) and keep in dataset

PGStats — Tue, 12 Jun 2018 03:18:39 GMT

option DSD removes the quotes. Try again without option DSD but keep option DLM=

topic How to read textfile that contain data with " (Double quote) and keep in dataset in SAS Programming

How to read textfile that contain data with " (Double quote) and keep in dataset

Re: How to read textfile that contain data with " (Double quote) and keep in dataset