char between double quote in sas export

[Srigyan]

I have a sas data set and I need to export in csv and that csv file needs to be imported somewhere else. We are not sure what delemeter can be used to seprate one column to another column.As you can say Record can have anything inside it. So taking any delimeter like comma,tab or space etc is risky.
1) Please suggest how to solve this problem.

2) One solution is my mind to replace (")double quote with (') single quote in RECORD field and cover char with (") double quote while export it. What code should be written.

            2.1) How to replace double quote with single quote.

            2.2) How to export csv file covering char field with double quote.

NAME	RECORD	AMOUNT	DATE
NAME-1	RECORD"1	20.83	17/10/2017
NAME-2	RECO,RD"2	9.86	30/05/2018
NAME-3	RECORD"3	5.68	05/08/2012
NAME-4	REC,ORD"4	3.21	01/06/2012
NAME-5	RECORD"5	465.37	03/10/2014

[Kurt_Bremser]

Use a delimiter you can be sure to not appear in the data, like the pipe (|), semicolon, or a tab ('09'x).

[RW9]

Why do you have a single double quote in the RECORD field?  That seems like a very bad idea, as it will most likely break any system or process you try to put it into and limits your export options.  I would highly recommend removing the double quotes in there and only using single quotes if you really have to, to avoid comlications.  

data want;
  set have;
  record=tranwrd(record,'"',"'");
run;

Should replace double quote with single.  Then you can export as csv, and surround all text data with double quotes.

Personally I would do data cleaning on RECORD column before doing anything further, remove all quotes, remove commas, remove any other character not needed.

[Srigyan]

how to export all char with double quote 

[Tom]

Just create a NORMAL csv file. In a CSV file values are separated by commas.  You can make a generalized version using a different delimiter. In fact in many European countries they use semi-colon as the delimiter because commas are use as decimal places and so appear frequently in numeric fields.

Values can OPTIONALLY be enclosed in quotes. When a value is quoted then embedded quotes should be doubled up. Note that values that contain the delimiter (comma) or quote character MUST be enclosed in quotes. 

Le'ts try it with your example data.

data have ;
  infile cards dsd dlm='|' truncover ;
  input NAME $ RECORD :$10. AMOUNT DATE :ddmmyy. ;
  format date yymmdd10. ;
cards;
NAME-1|RECORD"1|20.83|17/10/2017
NAME-2|RECO,RD"2|9.86|30/05/2018
NAME-3|RECORD"3|5.68|05/08/2012
NAME-4|REC,ORD"4|3.21|01/06/2012
NAME-5|RECORD"5|465.37|03/10/2014
;

filename csv temp;
data _null_;
  set have ;
  file csv dsd ;
  put (_all_) (+0);
run;

PS Don't use MDY or DMY order for dates. Which ever one you pick will confuse half of your global audience.

Result:

NAME-1,"RECORD""1",20.83,2017-10-17
NAME-2,"RECO,RD""2",9.86,2018-05-30
NAME-3,"RECORD""3",5.68,2012-08-05
NAME-4,"REC,ORD""4",3.21,2012-06-01
NAME-5,"RECORD""5",465.37,2014-10-03