https://communities.sas.com/t5/ODS-and-Base-Reporting/space-for-empty-value/m-p/1065#M509 instead of [PRE] dlm = ',' [/PRE]<BR /> use file statement option [pre] DSD [/pre]<BR /> <BR /> any time you're handling CSV structures, this option is important.<BR /> <BR /> Peter Wed, 19 Jul 2006 11:48:37 GMT deleted_user 2006-07-19T11:48:37Z https://communities.sas.com/t5/ODS-and-Base-Reporting/space-for-empty-value/m-p/1064#M508 file 'output.csv' dlm=',';<BR /> put protocol site screen dob lbdt hgb tsat ferr gfr_cb gfr;<BR /> <BR /> For the above code, if any values are empty, it puts a space in the output - so I get "aaa,bbb, ,ccc, ,ddd etc".<BR /> <BR /> How can I remove the space in the empty value?<BR /> Trim() &amp; Compress() didn't work.<BR /> <BR /> Thank you. Tue, 18 Jul 2006 21:44:55 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/space-for-empty-value/m-p/1064#M508 deleted_user 2006-07-18T21:44:55Z https://communities.sas.com/t5/ODS-and-Base-Reporting/space-for-empty-value/m-p/1065#M509 instead of [PRE] dlm = ',' [/PRE]<BR /> use file statement option [pre] DSD [/pre]<BR /> <BR /> any time you're handling CSV structures, this option is important.<BR /> <BR /> Peter Wed, 19 Jul 2006 11:48:37 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/space-for-empty-value/m-p/1065#M509 deleted_user 2006-07-19T11:48:37Z https://communities.sas.com/t5/ODS-and-Base-Reporting/space-for-empty-value/m-p/1066#M510 Thank you! Wed, 19 Jul 2006 13:29:38 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/space-for-empty-value/m-p/1066#M510 deleted_user 2006-07-19T13:29:38Z