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?
