topic Proc Report (Customizing output report) in SAS Procedures

Proc Report (Customizing output report)

Nishant_saxena — Mon, 03 Jul 2017 17:30:45 GMT

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.

Re: Proc Report (Customizing output report)

PaigeMiller — Mon, 03 Jul 2017 18:49:01 GMT

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=;

Re: Proc Report (Customizing output report)

Nishant_saxena — Tue, 04 Jul 2017 07:20:25 GMT

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??

Re: Proc Report (Customizing output report)

PaigeMiller — Tue, 04 Jul 2017 11:48:02 GMT

PROC SORT