Proc Report (Customizing output report)

[Nishant_saxena]

Hi all,

I need help in customizing my report generated by using proc report.

code I tried is:

proc means data=olympics_digi_cleaned sum descending ;
class _probability___;
var Total_Media_value;
run;

Output is attached in attachments.

What I want is :

(1)   To display Prob_Digi in place of _probablity___  as my column name

(2)    to display all the data in reverse order i.e _probablity 100 will be my first observation and 0 will be my last observation

(3)   To display sum o all observation in sum column at last

(4)   At last I also want to add a column that contain the product of _probablity___ and sum.

[PaigeMiller · Accepted solution]

All of this should be easy to do if you output the results of PROC MEANS to a SAS data set, and then perform the modificaitons you want on the PROC MEANS output using a SAS data step or another PROC, then do a PROC PRINT or PROC REPORT.

To output the data from PROC MEANS to a SAS data set named _results_, use this code as the last command of PROC MEANS (just above the run; command)

output out=_results_ sum=;

[Nishant_saxena]

hi there by inserting this line:

output out= _result_ sum=;

eveything is done 

But how to display my table in reverse order

i.e. 100 will be my first observation and 10 will be my last observation??

[PaigeMiller]

PROC SORT