I am trying to sort the columns of the html output using tableeditor tagset.
The sorting works fine for all the columns but two columns.
Those columns has negative values formatted as percent .
Here is the code I am using.The two variables I am having trouble with are growth and contrib.
Does anyone have similar problem or is it something in my code ?
Please help.
ods listing close;
ods tagsets.tableeditor file="//testfilter.html" style=sasweb
options(sort="yes" sort_arrow_color="brown" exclude_summary="yes"
data_type="String,String,Number,String,String,Numberx,Numberx"
autofilter="yes"
frozen_headers="yes"
autofilter_width="7em"
autofilter_table="1"
);
proc report data=tempGrp3 nowd;
title "Bxxx Fxxx Item Level Exceptions";
Columns Category Sub_Category Item Part_Number Description growth contrib;
define growth / format=percent10.1 'GROWTH';
define contrib / format = percent10.3 'IMPACT';
*rbreak after/summarize;
run;
ods tagsets.tableeditor close;
ods listing;