separators in export files

MILKYLOVE — Thu, 16 Jun 2022 07:43:35 GMT

Hello all,

I'm trying to export a csv file using the %ds2csv macro.

I want to put the delimiter semi column ' ; ' instead of comma ' , ' or ' | '

My code is below

%ds2csv

(data = work.myfile, runmode = b, csvfile = &file.&mydir./myfile.csv, sepchar = 7C, colhead = y);

Which sepchar should I use for semi column ' ; ' please?

Re: separators in export files

ballardw — Thu, 16 Jun 2022 08:41:35 GMT

If your system is using ASCII characters then Sepchar=3B should work.