Proc Report Suppress dots for missing values

[RRGanapathy]

Dear SAS Community,

In continuation of the topic discussed in the thread below, is there anyway to display the period(dot) as empty numeric cell in Proc Report without creating any additional space. 

https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-suppress-missing-value-indicators-i...

Thanks,

RR

[PaigeMiller]

---

@RRGanapathy wrote:

In continuation of the topic discussed in the thread below, is there anyway to display the period(dot) as empty numeric cell in Proc Report without creating any additional space. 

---

What does "without creating any additional space" mean?

[RRGanapathy]

Hi Paige Miller,

I tried with the setting, option missing='', it replaces the dot with blank space(infact the dot is replaced) in excel but then in the excel report, I see 8 spaces as it is the default space allocated. I would like this to be an empty cell with no allocated space.

You ll see something like this, when you copy the excel cell in a notepad.

[PaigeMiller]

Your screen capture provides no context, as we can't see cells that have actual data in them for comparison.

Show us what you want, and show us what you are getting, so we can see more of the picture.

[Kurt_Bremser]

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.