PROC REPORT sorting ANALYSIS variables

[SusieQ324]

Is it possible to sort an ANALYSIS defined variable in descending order? I haven't found the option that's applicable to the ANALYSIS definition.

Thanks!

Sue

[Cynthia_sas]

Hi:
Look at Example 3 in this paper:
http://www2.sas.com/proceedings/forum2008/173-2008.pdf

You can't sort directly on an ANALYSIS variable -- if your report is a SUMMARIZED report -- however, you can make a copy of the analysis variable and then use that copy of the variable's summarized value to control ordering. That's what Example 3 shows.

If you have a DETAIL report -- where each report row represents 1 observation in the data set -- then you can control the order of the detail report by sorting the way you want with PROC SORT -- before the PROC REPORT step. Then if you list your variables as just DISPLAY and ANALYSIS, you will get the SORT order in your report.

cynthia

[SusieQ324]

Thanks Cynthia!

I had found that paper yesterday and that's how I circumvented the problem - summarized the data ahead of time and then used that as an ORDER variable and that worked perfectly.

Thanks for the response.

Sue