numeric missing values - export in excell

[Tecla1]

Hello everyone,

is it possible to avoid exporting the "dot" in empty numeric cells to excell?

Thank you very much,

Tecla

[PeterClemmensen]

How do you export to Excel?

[Tecla1]

Hi, Tnks, 

ods excel file="&outputname."
options(autofilter="1-6" sheet_name="&sheetname.");

proc print data=&libname..&dataname. label;
run;

ods excel close;

[PeterClemmensen · Accepted solution]

Try using

options missing="";

before the Proc Print 

[Tecla1]

Thank you very much Peter!! The whole community is always very helpful and kind... I wish everyone a very happy new year!!