I have MEAN values after doing a summary
Category Mean
A 3.56
B 2.59
C 8.54
If i use these mean values in the proc report with Display option in the define statement instead of Analysis as shown
define mean/display
and do a rbreak after / summarize;
Will I get missing values for Subtotal(break) and Total(rbreak) of MEAN variable????.I dont want to do a analysis because they are already Mean values
For other variables I want to use analaysis though to find the COUNTS etc
Thanks
Hi, you can always make a test program to figure out the answer to these types of questions. See the example below. Since you referred to both BREAK and RBREAK, I made a few ORDER items so the report could have both a BREAK and RBREAK statement.
If you run the code, you will see that when a numeric report item has a usage of DISPLAY, there is *NOTHING* calculated for the item at any of the break lines. So it is not "missing", there is just an empty cell.
cynthia
data test;
infile datalines;
input Othergrp $ Category $ Mean Counts FakeNum;
return;
datalines;
www A 3.56 100 999
www B 2.59 150 888
www C 8.54 125 777
xxx A 2.56 100 122
xxx B 1.59 150 233
xxx C 7.54 125 344
yyy A 2.56 100 221
yyy B 2.19 150 332
yyy C 6.54 125 443
;
run;
ods html file='c:\temp\testreport_usage.html' style=sasweb;
proc report data=test nowd;
column othergrp category mean counts fakenum;
define othergrp / order;
define category / order;
define mean / display;
define counts / sum f=comma6.;
define fakenum / sum f=comma6.;
rbreak after / summarize;
break after othergrp / summarize;
run;
ods html close;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.