topic Re: OPTIONS MISSING='0' in SAS Programming

OPTIONS MISSING='0'

Jaheuk — Tue, 07 Sep 2010 10:20:13 GMT

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.

Re: OPTIONS MISSING='0'

polingjw — Tue, 07 Sep 2010 11:18:37 GMT

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;

Re: OPTIONS MISSING='0'

Jaheuk — Tue, 07 Sep 2010 11:35:56 GMT

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.

Re: OPTIONS MISSING='0'

sbb — Tue, 07 Sep 2010 17:43:51 GMT

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.