DATA Step, Macro, Functions and more

convert numeric missing values to blank

Reply
Super Contributor
Posts: 673

convert numeric missing values to blank

how to convert numeric missing(.) to blank?

i tried the loop

array num(*) _numeric_;
do i= 1 to dim(num);
if num(i)=. then num(i)=;
end;

it did not work though!
SAS Super FREQ
Posts: 8,867

Re: convert numeric missing values to blank

Hi,
A simple
[pre]
options missing = ' ';
[/pre]

Should do the trick for reporting purposes.

Cynthia
Super Contributor
Super Contributor
Posts: 3,174

Re: convert numeric missing values to blank

Posted in reply to Cynthia_sas
Useful DOC reference from links using Google advanced search argument, this topic/post:

working with missing values site:sas.com

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 2 replies
  • 121 views
  • 0 likes
  • 3 in conversation