BookmarkSubscribeRSS Feed
MILKYLOVE
Calcite | Level 5

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?

 

 

1 REPLY 1
ballardw
Super User

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 573 views
  • 1 like
  • 2 in conversation