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.
Thanks,
RR
@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?
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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.