DATA Step, Macro, Functions and more

Reset options missing

Reply
New Contributor
Posts: 2

Reset options missing

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!

Super User
Posts: 19,805

Re: Reset options missing

Option missing=.;

New Contributor
Posts: 2

Re: Reset options missing

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;

Super User
Posts: 19,805

Re: Reset options missing

What about 

 

option missing='.';

Ask a Question
Discussion stats
  • 3 replies
  • 696 views
  • 0 likes
  • 2 in conversation