Change delimiter when using ods csv

[deleted_user]

Hi,

I create a csv file using ods csv. I wanted to change the delimiter to ";" instead of "," but that did not work. I do not get error messages but I still get a comma separated file.

This is my code:
ods csv(2) file="&path/listings/pk_csv_listing.csv" options(delimiter=';');

Does anybody have an idea what I can do?
Just for information, I am using SAS9 on an Unix environment.

Thanks a lot,
Konstanze

[Cynthia_sas]

Hi:
If you are running SAS 9.1.3, you can download the updated CSV tagset template from here (I believe the latest is April 2006). That should allow you to use the delimiter= suboption. When I tested the delimiter= suboption in SAS 9.2, there were no issues and I got semicolons as the delimiter. To determine which version of the tagset you are running, look

The download site is:
http://support.sas.com/rnd/base/ods/odsmarkup/ (scroll to CSV link)

Directions for updating your template item store and using ODS PATH are here:
http://support.sas.com/kb/32/394.html

cynthia