topic Reset options missing in SAS Programming

Reset options missing

macatue — Wed, 20 Jul 2016 04:12:43 GMT

Hi, Can anyone please help me. I have set options missing = " " to display . numeric values as missing when exported to excel. Using a different SAS session, I am still getting the same result. How do I reset this option and go back to the default so that the display value for missing numeric values is . and not missing. Thank you so much!

Re: Reset options missing

Reeza — Wed, 20 Jul 2016 04:28:50 GMT

Option missing=.;

Re: Reset options missing

macatue — Wed, 20 Jul 2016 06:04:49 GMT

Thank you Reeza for answering. I tried it but . still shows up as (blank) instead of its original value.

data test;
a=.;
b=0;
c=1;
run;

option missing=.;

proc export data = test
outfile = "Desktop\Display Missing.xlsx"
dbms = excel replace;
sheet = "test";
run;

Re: Reset options missing

Reeza — Wed, 20 Jul 2016 06:06:14 GMT

What about

option missing='.';