topic Re: E.G. Displaying the data in a Summary Table Report in Descending or Ascending order by the data column in SAS Enterprise Guide

E.G. Displaying the data in a Summary Table Report in Descending or Ascending order by the data column

BillB — Fri, 20 Sep 2013 15:45:11 GMT

I have an output table that has Company Codes (Rows) and data (Currency) in a column.

I want to be able to show in the Summary Report the Currency column in Descending or Ascending order without using re-coding as an option.

Any ideas?

Bill

Reeza — Fri, 20 Sep 2013 18:53:07 GMT

So you want the data ordered by the counts? Eg, top dollar groups first or last?

I think you can go to the code, preview code and modify the code. Add ORDER=FREQ the proc tabulate line.

I don't see an option to do that in EG 4.3, perhaps that's changed in later versions though.

nrose — Tue, 24 Sep 2013 11:48:24 GMT

Reeza — Tue, 24 Sep 2013 14:51:25 GMT

Unfortunately that controls the Class levels, not based on the data values in the report.

For example with Cars and descending option on make (analysis variable= mpg(city))

TomKari — Tue, 24 Sep 2013 20:47:50 GMT

Which task are you using to create the report?

Tom