SAS DI File Reader Issues CSV Text Qualifier DSD

jdmarshg — Sat, 26 Sep 2015 00:21:08 GMT

"JOE0891","08/22/2014 00:00:00","01/02/2013 00:00:00","alphacode","hello"

I'm trying to get a file reader to render a csv with double quotes as the text identifiers.

When have the infile statement displayed I see the dsd option specified.

I thought this would strip out the " around the values.

Still have issues getting the file to be rendered.

Still researching infile statements to see if I need to override.

Any suggestions

Regards,

Jonathan

Re: SAS DI File Reader Issues CSV Text Qualifier DSD

jdmarshg — Sat, 26 Sep 2015 00:56:52 GMT

Resolved with format and informat and was able to get the file reader to render results.

Was just a matter of the right formatting.

the DSD removed the "".

infile '/data/asyouwish/blah/blah/blahblah/sourcefiles/*.csv'
lrecl = 500
delimiter = ','
dsd
missover
firstobs = 2;

Regards,

Jonathan

topic Re: SAS DI File Reader Issues CSV Text Qualifier DSD in SAS Data Management

SAS DI File Reader Issues CSV Text Qualifier DSD

Re: SAS DI File Reader Issues CSV Text Qualifier DSD