topic tagattr using percentage in ODS and Base Reporting

tagattr using percentage

Q1983 — Fri, 16 Dec 2016 19:15:15 GMT

data test(keep=contg_mult);

set test1;

run;

Sample Data

contg_mult
5000

10000

150

In ods I have this

DEFINE contg_mult / Display style(column)={tagattr="format:00000.00" cellwidth=80pt just=right} "Contingency Percent";

I am attempting to display as

contg_mult
50.00

100.00

1.50

with no percentage sign.

Can I achieve this desired format in ods or is there a way to do this in the dataset itself

Re: tagattr using percentage

Jagadishkatam — Fri, 16 Dec 2016 19:33:57 GMT

put a new define statement like below in proc report along with compute block and the newvar will have the values as expected.

define newvar / computed Display style(column)={tagattr="format:000.00" cellwidth=80pt just=right} "Contingency Percent";

compute newvar;
newvar=contg_mult/100;
endcomp;

Re: tagattr using percentage

Jagadishkatam — Fri, 23 Dec 2016 01:29:42 GMT

Hope you checked it and it worked.