DATA Step, Macro, Functions and more

Create a format to change . to blank

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

Create a format to change . to blank

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 Smiley Happy


Accepted Solutions
Solution
‎08-21-2013 02:26 PM
Respected Advisor
Posts: 4,640

Re: Create a format to change . to blank

Use option missing= instead :

option missing=' ';

< Some code >

option missing='.';

PG

PG

View solution in original post


All Replies
Solution
‎08-21-2013 02:26 PM
Respected Advisor
Posts: 4,640

Re: Create a format to change . to blank

Use option missing= instead :

option missing=' ';

< Some code >

option missing='.';

PG

PG
Contributor
Posts: 22

Re: Create a format to change . to blank

Thanks so much Smiley Happy

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 168 views
  • 0 likes
  • 2 in conversation