The SAS Output Delivery System and reporting techniques

space for empty value?

Reply
N/A
Posts: 0

space for empty value?

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.
N/A
Posts: 0

Re: space for empty value?

Posted in reply to 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
N/A
Posts: 0

Re: space for empty value?

Posted in reply to deleted_user
Thank you!
Ask a Question
Discussion stats
  • 2 replies
  • 133 views
  • 0 likes
  • 1 in conversation