Hi all, Two questions:
#1 - autosort with decimals and/or percent signs
I was just wondering if anyone had any thoughts on sorting numbers with decimals. I actually have numbers I format as percent8.2 and output with proc report (column is set for display). The sort='yes' function of the tagset works, but it sorts it as text. I thought perhaps it was because of the percent sign so I tried just outputting the number*100 to avoid the percent sign but it still sorts like text. Perhaps it is the decimal? Unfortunately I need to present whole numbers to two decimal points, but I could live without percent signs. Anyone have any clever workaround ieas? Example of how my data is sorting (descening obviously):
[pre] 25.72
3.13
30.00
4.17
4.35[/pre]
#2 autofilter columns - limiting to just 3 columns
Same table as above (proc report in ods tagsets.tableeditor). If I use just sort='yes' then sort works. If I use sort='yes and auto_filter='yes' then I can sort and all columns have (populated) filter boxes. What I really want is filter boxes on just 3 columns. Below is the code I use, but when I add filter_cols='1,2,3' sort doesn't work and no filter boxes show up. Saw this in both IE7 and IE8.
[pre]
ods tagsets.tableeditor style=analysis
path="c:\temp\" body="test.htm"(title="test level")
options(highlight_color='#fff8cd' sort='yes' autofilter='yes' filter_cols='1,2,3');
[/pre]
One more strange twist is that if I say filter_cols='2,3' then all the columns have filter boxes, but only col2 and col3 have values in them.