DATA Step, Macro, Functions and more

OPTIONS MISSING='0'

Reply
Frequent Contributor
Posts: 89

OPTIONS MISSING='0'

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.
Regular Contributor
Posts: 171

Re: OPTIONS MISSING='0'

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;
Frequent Contributor
Posts: 89

Re: OPTIONS MISSING='0'

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.
Super Contributor
Super Contributor
Posts: 3,174

Re: OPTIONS MISSING='0'

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.
Ask a Question
Discussion stats
  • 3 replies
  • 232 views
  • 0 likes
  • 3 in conversation