The SAS Output Delivery System and reporting techniques

Change delimiter when using ods csv

Reply
N/A
Posts: 0

Change delimiter when using ods csv

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
SAS Super FREQ
Posts: 8,861

Re: Change delimiter when using ods csv

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 387 views
  • 0 likes
  • 2 in conversation