how to read character data that has quotation.

[nbonda]

I have a code that read a text file, with delimiter pipe (|)

data sample;

Infile 'C:\mydata\test.txt' DSD  DLM='|'  LRECL=1024 MISSOVER  FIRSTOBS=1 TERMSTR=LF;

Input     fname :$CHAR20.

            lname :$CHAR30.

           city :$CHAR40.

run;

sample text file:

Jen|Turner|'Chicago'

David||'New York'

Michael|ybarra|Detroit

If I use DSD option ,SAS not  reading single quotes and consecutive delimiters reading as missing value...., Without DSD option SAS reads single quotes, but  consecutive delimiters are not reading as missed value.

Is there any infile options or a statement that reads single quotations in data and consider missing value for consecutive delimiter.? Thank you

[PGStats · Accepted solution]

Use the tilde format modifier :

data sample;

length fname $20 lname $30 city $40;

Infile datalines dsd DLM='|' MISSOVER;

Input fname ~ lname ~ city ~;

datalines;

Jen|Turner|'Chicago'

David||'New York'

Michael|ybarra|Detroit

;

proc print data=sample; run;

PG

[nbonda]

Is there any other option without changing my entire code . Because I have 30 similar code with lot of  variables in input statement.

[Ksharp]

Code: Program

data sample;

Infile datalines dsd DLM='|' MISSOVER;
Input fname ~ : $20. lname ~ :$20. city ~ : $20.;
datalines;
Jen|Turner|'Chicago'
David||'New York'
Michael|ybarra|Detroit
;
run;