space for empty value?

[deleted_user]

file 'output.csv' dlm=',';
put protocol site screen dob lbdt hgb tsat ferr gfr_cb gfr;

For the above code, if any values are empty, it puts a space in the output - so I get "aaa,bbb, ,ccc, ,ddd etc".

How can I remove the space in the empty value?
Trim() & Compress() didn't work.

Thank you.

[deleted_user]

instead of [PRE] dlm = ',' [/PRE]
use file statement option [pre] DSD [/pre]

any time you're handling CSV structures, this option is important.

Peter

[deleted_user]

Thank you!