https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47352#M6163 Thanks Cynthia Tue, 20 Jul 2010 06:03:42 GMT kedar 2010-07-20T06:03:42Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47347#M6158 %ds2csv - how to remove qouble quote from each field in output files Mon, 12 Jul 2010 06:32:00 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47347#M6158 kedar 2010-07-12T06:32:00Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47348#M6159 Share your code that is contributing to the condition - also, did you review the available documentation? And, knowing your SAS version, OS platform, as well as contributing your code and possibly even a sample output row with the condition revealed would be most helpful.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Recommended Google advanced search argument, this topic / post:<BR /> <BR /> ds2csv site:sas.com Mon, 12 Jul 2010 12:49:17 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47348#M6159 sbb 2010-07-12T12:49:17Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47349#M6160 Hi:<BR /> Do you want to remove the quotes from EACH field or only from the numeric fields???<BR /> <BR /> You might try using the ODS CSV method of creating a CSV file instead of %DS2CSV. It only quotes the character fields and leaves the numeric fields unquoted.<BR /> <BR /> cynthia<BR /> [pre]<BR /> %ds2csv (data=sashelp.class, runmode=b, csvfile=c:\temp\ds_method.csv);<BR /> <BR /> ods csv file='c:\temp\alt_method.csv';<BR /> proc print data=sashelp.class;<BR /> run;<BR /> ods csv close;<BR /> [/pre] Mon, 12 Jul 2010 14:24:46 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47349#M6160 Cynthia_sas 2010-07-12T14:24:46Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47350#M6161 Hi, <BR /> <BR /> I want to remove quotes from EACH field. <BR /> <BR /> I have input SAS table. I want to execute above code in mainframe. It will work? Wed, 14 Jul 2010 07:17:07 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47350#M6161 kedar 2010-07-14T07:17:07Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47351#M6162 ODS CSV will work on the mainframe (as long as you have SAS 8.2 or higher). The only difference is that the FILE= option would point to the mainframe file that you were creating, instead of a C drive location. However, unless your file is all numeric variables, it sounds like ODS CSV won't do what you want. When you use ODS CSV, character values are still quoted.<BR /> <BR /> You may need to investigate writing a DATA step program where you write out the variable values to an external (sequential) file without any quotes.<BR /> <BR /> cynthia Wed, 14 Jul 2010 10:49:14 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47351#M6162 Cynthia_sas 2010-07-14T10:49:14Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47352#M6163 Thanks Cynthia Tue, 20 Jul 2010 06:03:42 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ds2csv-how-to-remove-qouble-quote-from-each-field/m-p/47352#M6163 kedar 2010-07-20T06:03:42Z