topic Proc Report Suppress dots for missing values in ODS and Base Reporting

Proc Report Suppress dots for missing values

RRGanapathy — Mon, 25 Apr 2022 11:11:41 GMT

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-in-PROC/td-p/167931

Thanks,

Re: Proc Report Suppress dots for missing values

PaigeMiller — Mon, 25 Apr 2022 11:23:58 GMT

@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?

Re: Proc Report Suppress dots for missing values

RRGanapathy — Tue, 26 Apr 2022 08:38:00 GMT

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.

Re: Proc Report Suppress dots for missing values

PaigeMiller — Tue, 26 Apr 2022 10:13:20 GMT

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.

Re: Proc Report Suppress dots for missing values

Kurt_Bremser — Tue, 26 Apr 2022 10:45:54 GMT

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.