You can COMPUTE a variable:
data have;
input x;
datalines;
1
.
;
ods excel file="~/miss.xlsx";
proc report data=have;
column x _x;
define x / noprint;
define _x / computed right;
compute _x / character;
if _c1_ = .
then _x = "";
else _x = put(_c1_,8.);
endcomp;
run;
ods excel close;
Cell A3 will be empty, while A2 can still be used in calculations.
... View more