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?
option DSD removes the quotes. Try again without option DSD but keep option DLM=
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.