topic Create a format to change . to blank in SAS Programming

Create a format to change . to blank

Shirin — Wed, 21 Aug 2013 18:20:44 GMT

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 — Wed, 21 Aug 2013 18:26:40 GMT

Use option missing= instead :

option missing=' ';

< Some code >

option missing='.';

Shirin — Wed, 21 Aug 2013 18:31:14 GMT

Thanks so much