BookmarkSubscribeRSS Feed
jdmarshg
Obsidian | Level 7

"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

1 REPLY 1
jdmarshg
Obsidian | Level 7

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

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1270 views
  • 0 likes
  • 1 in conversation