DATA Step, Macro, Functions and more

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

Reply
Occasional Contributor
Posts: 9

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

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?

Esteemed Advisor
Posts: 5,475

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

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

PG
Ask a Question
Discussion stats
  • 1 reply
  • 63 views
  • 0 likes
  • 2 in conversation