I have a SAS dataset that has a couple of columns that are 1 character in length. When exporting the dataset as a comma delimited file I want to replace NULLS with a single blank space in the txt file. For example I'm looking for the output to be: T,S123, , , ,1.2,P vs T,S123,,,,1.2,P I need a single space placed between the commas when data is missing. I've tried proc export, and it works great except I for the issue I'm having with replacing nulls with a space: proc export data = ds.pkts dbms=csv label outfile="C:xyz\file.txt" replace; run;
... View more