Create a format to change . to blank

[Shirin]

Can I create a format to change . to blanks?

I don't wanna see . for the missing numerical data.

I did a simple proc format and it doesnt seem to work:

proc format;

value blank

. = ' ';

run;

data datasetname;

set datasetname;

format var1 var2 var3 var4 blank.;

run;

Thanks for your help

[PGStats · Accepted solution]

Use option missing= instead :

option missing=' ';

< Some code >

option missing='.';

PG

[Shirin]

Thanks so much