topic Re: PROC REPORT sorting ANALYSIS variables in SAS Procedures

PROC REPORT sorting ANALYSIS variables

SusieQ324 — Thu, 15 Jan 2009 15:02:48 GMT

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

Re: PROC REPORT sorting ANALYSIS variables

Cynthia_sas — Fri, 16 Jan 2009 16:22:41 GMT

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

Re: PROC REPORT sorting ANALYSIS variables

SusieQ324 — Fri, 16 Jan 2009 16:29:20 GMT

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