The SAS Output Delivery System and reporting techniques

tableeditor proc report sort

Reply
N/A
Posts: 0

tableeditor proc report sort

I'm having trouble getting my proc report output to sort correctly (using tableeditor).
It currently sorts my values as: 9, 8, 7, 2, 16.
I tried this, but it didn't help:
define osha_rate1 / analysis 'OSHA Rate' format=5.2 style(header)={tagattr="type='Number'"};
Thank you.
SAS Super FREQ
Posts: 8,743

Re: tableeditor proc report sort

Hi:
I think that TAGSETS.TABLEEDITOR builds and HTML file with embedded JavaScript to load the HTML file into Excel. I'm not sure that TAGATTR style override works with TAGSETS.TABLEEDITOR. You'd have to check that with Tech Support.

However, in your other posting on this topic, you showed OSHA_RATE1 nested UNDERNEATH a YEAR (ACROSS) item. This means that YEAR order is primary and OSHA_RATE1 is not really being sorted, so much as it is being PLOPPED underneath each year.

I still recommend that you work with Tech Support on this issue.
cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 123 views
  • 0 likes
  • 2 in conversation