How to control order in proc report?

Reply
Contributor
Posts: 30

How to control order in proc report?

Hi,

    I have a data set, contains three variables: State, Servicer & UPB. I want to my report first order in state, then in each state, descending order in UPB.

   My code is something like:

   proc data = mmm; by state descending UPB; run;

   proc report data = mmm .......

   define state /group;

   define servicer / order ?;

   define UPB / order order=date;

   ....

   Your help will be really appreciated.

   Thanks.

Jian

Super User
Posts: 9,671

Re: How to control order in proc report?

define state /order;

   define UPB / order desc ;

Ask a Question
Discussion stats
  • 1 reply
  • 128 views
  • 0 likes
  • 2 in conversation