topic Re: Changing the delimiter in the ods csv in ODS and Base Reporting

Changing the delimiter in the ods csv

DanieleTiles — Wed, 02 Dec 2009 18:32:00 GMT

Hi to all,
I've to produce a csv with ';' as delimiter. I've searched for documentation, and found that it should be done by using

ods csv file='c:\test' options(delimitator=';');

...

...but it doesn't work, I still get a ',' as dlm.
Any idea?
Thanks

Daniele

Re: Changing the delimiter in the ods csv

sbb — Wed, 02 Dec 2009 18:56:48 GMT

I believe that the option (check your spelling, by the way) is only supported at SAS 9.2. and later.

Scott Barry
SBBWorks, Inc.

Re: Changing the delimiter in the ods csv

Cynthia_sas — Wed, 02 Dec 2009 18:57:17 GMT

Hi:
Check your syntax, I believe the suboption is DELIMITER, not DELIMITATOR. You may need to update the CSV tagset that you're using, especially if you're working in SAS 9.1.3. See this previous posting for more info:
http://support.sas.com/forums/thread.jspa?threadID=5414

When I run the below code in SAS 9.2, I get the ';' used as the delimiter. I believe the delimiter capability was accomplished in SAS 9.1.3 by using an updated CSV tagset template.

cynthia

[pre]
ods csv file='c:\temp\csvtest.csv'
options(doc='Help' delimiter=";");
proc print data=sashelp.class(obs=3);
run;
ods csv close;
[/pre]

Re: Changing the delimiter in the ods csv

sbb — Wed, 02 Dec 2009 19:00:22 GMT

Searching the SAS discussion forum archives with keywords "ods csv change delimiter", the gem below appears in the match-results:

http://support.sas.com/forums/thread.jspa?messageID=19459䰃

I stand corrected - the support comes with an updated tagset.

Scott Barry
SBBWorks, Inc.