topic numeric missing values - export in excell in SAS Programming

numeric missing values - export in excell

Tecla1 — Wed, 18 Dec 2024 08:15:28 GMT

Hello everyone,

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

Thank you very much,

Tecla

PeterClemmensen — Wed, 18 Dec 2024 08:16:09 GMT

How do you export to Excel?

Tecla1 — Wed, 18 Dec 2024 08:18:10 GMT

Hi, Tnks,

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

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

ods excel close;

PeterClemmensen — Wed, 18 Dec 2024 08:22:07 GMT

Try using

options missing="";

before the Proc Print

Tecla1 — Wed, 18 Dec 2024 08:28:53 GMT

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