OPTIONS MISSING='0'

[Jaheuk]

when printing a "missing" you can choose the character that is printed i.e. 0
is the other way (without data step programming) also possible: when een var=0 treat it as a missing??

H.

[polingjw]

If I understand your question correctly, you could just apply a user defined format. For example...

data temp;
input var1;
datalines;
5
0
3
0
;
run;

proc format;
value num 0 = '.';
run;

proc print data=temp;
format var1 num.;
run;

[Jaheuk]

hi poling,
that's what i first did:
proc format ;
VALUE ZERO
0 = ' '
other = [commax15.]
;
RUN;

but then i have another problem 😉

look at: http://support.sas.com/forums/message.jspa?messageID=42147


H.

[sbb]

Again - where is the SAS code/program that references the FORMAT you created? You have not shared that information - and it would be best served by pasting the SAS log into your post-reply to show a DATA step with a PUT statement to demonstrate that the format is not being accessed.

Scott Barry
SBBWorks, Inc.