topic Re: Percentage display adding zeros in ODS in ODS and Base Reporting

Percentage display adding zeros in ODS

Q1983 — Mon, 30 Jan 2017 16:47:16 GMT

data test (keep=pct);

set test1;

run;

sample output

100

In ODS i have this

DEFINE pct /DISPLAY style(column)={tagattr='format:#0%'} "%Processed";

My output looks like this

%Processed
1000%

5000%

7000%

I am getting the desired percent sign however I am getting two extra zeros. How can I get rid of the extra zeroes

Re: Percentage display adding zeros in ODS

ballardw — Mon, 30 Jan 2017 17:36:12 GMT

PERCENT format is intended for values of 0 to 1 where 1=100%. So either divide your numbers by 100 or use a custom picture format to add a % at the end of any value.

Re: Percentage display adding zeros in ODS

Cynthia_sas — Thu, 02 Feb 2017 14:39:19 GMT

Hi:
In addition, when you use a format such as you show in TAGATTR, Excel automatically does a multiply by 100...please see this paper: https://support.sas.com/resources/papers/proceedings11/266-2011.pdf where data on page 16 is shown as 0.099 and 0.082 and with a tagattr similar to yours, Excel displays the number as though it has been multiplied by 100.

--- Including a percent sign in TAGATTR format without a backslash will cause Excel to multiply the number by 100. Example:
.1234 internal value with TAGATTR of 0.0#% will be displayed as 12.34%

---Including a percent sign WITH a backslash in the format will display the percent sign, but will NOT multiply the number by 100. Example:
.5678 internal value with TAGATTR of 0.00\% will be displayed as 0.57%

cynthia