topic HOW TO GIVE ORDER TO COMPUTED VARIABLES IN PROC REPORT in SAS Procedures

HOW TO GIVE ORDER TO COMPUTED VARIABLES IN PROC REPORT

kuridisanjeev — Wed, 01 Feb 2012 06:49:02 GMT

Dear all,

name	subject1	subject2
sanjeev	35	40
chaithu	99	100
karthik	56	25
ramakanth	25	96
shiva	10	99

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 ;

compute total;

total=_c2_/_c3_;

endcomp;

run;

help me....

HOW TO GIVE ORDER TO COMPUTED VARIABLES IN PROC REPORT

Eva — Wed, 01 Feb 2012 08:56:15 GMT

Dear kuridisanjeev,

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.

Best wishes,

Eva