Help using Base SAS procedures

PROC REPORT sorting ANALYSIS variables

Reply
Occasional Contributor
Posts: 18

PROC REPORT sorting ANALYSIS variables

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
SAS Super FREQ
Posts: 8,781

Re: PROC REPORT sorting ANALYSIS variables

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
Occasional Contributor
Posts: 18

Re: PROC REPORT sorting ANALYSIS variables

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
Ask a Question
Discussion stats
  • 2 replies
  • 130 views
  • 0 likes
  • 2 in conversation