I need to output the data to text file but the missing value must be converted to "." . I have tried to use option missing but it's the same (.) as null value, thus the output still blank instead of (.) . Please help. Thanks.   temp_data: Model   Type   Month_1   Month_2   Month_3  Month_4 A   FIRE   123.4   5   56.7   23.86 B   FIRE   2349   35.3   .   . C              234.8   .   .   .   text file: A|FIRE|123.4|5|56.7|23.86 B|FIRE|2349|35.3|.|. C||234.8|.|.|.   option missing = '.' ; proc export data=temp_data outfile="&path" dbms=dlm replace; putnames=no; delimiter="|"; run; ... View more