02-01-2012 01:49 AM
I am applying proc report to above data and computing new variale "total" by adding subject1 and subject2.
i want to print that new variable in descending order....
proc report data=test;
columnname subject1 subject2 total;
define total/computed ;
02-01-2012 03:56 AM
I don't think that this is possible within the same proc report. Because proc report works from top the bottom and within that from left to right. You would need a step after that to sort the data.
I suggest you do the sum for "total" in a data step before the proc report and then do the proc report and define the new variable as order / group.