Incorrect Row percent in Proc Report

UserSAS7 — Thu, 07 Sep 2023 17:21:10 GMT

Hi all,
For my data, in Proc Report, I am trying to calculate row percentages in an across variable, for grouped data. I am using the following code and for all observations, it is generating right result except for one where only _c2 is 0. I am unable to figure out why it is happening that way.

proc report data= mydata;

columns ('Heading1' label)

classval,(n pct) ("Mean Rating" varval) ("N" all);

define label / group " ";

define classval / across order=formatted "Rating" format=rating. ;

define n / "count" ;

define pct / computed "%" format=percent9.2;

define varval / mean " " format=8.2;

define all / computed " " format=8.;

compute pct;

_c3_ = _c2_ /(_c2_ + _c4_ + _c6_ + _c8_ );

_c5_ = _c4_ /(_c2_ + _c4_ + _c6_ + _c8_ );

_c7_ = _c6_ /(_c2_ + _c4_ + _c6_ + _c8_ );

_c9_ = _c8_ /(_c2_ + _c4_ + _c6_ + _c8_ );

endcomp;

compute all;

all = _c2_ + _c4_ + _c6_ + _c8_ ;

endcomp;

run;

Output :

Heading1	1	1	2	2	3	3
	count	%	count	%	count	%	count	%	mean	N
observation1	37	35.58%	31	29.81%	21	20.19%	15	14.42%	2.13	104
observation2	21	20.19%	31	29.81%	31	29.81%	21	20.19%	2.5	104
observation3	20	19.42%	32	31.07%	33	32.04%	18	17.48%	2.48	103
observation4	12	11.65%	29	28.16%	40	38.83%	22	21.36%	2.7	103
observation5	0	0	10	0	53	0	39	0	3.28	0
observation6	9	8.82%	16	15.69%	50	49.02%	27	26.47%	2.93	102
observation7	4	3.85%	24	23.08%	41	39.42%	35	33.65%	3.03	104
observation8	19	18.45%	29	28.16%	31	30.10%	24	23.30%	2.58	103
observation9	17	16.50%	29	28.16%	34	33.01%	23	22.33%	2.61	103

Re: Incorrect Row percent in Proc Report

Kurt_Bremser — Thu, 07 Sep 2023 17:58:45 GMT

Could it be that you have in fact a missing value, and set OPTIONS MISSING to 0?

Re: Incorrect Row percent in Proc Report

UserSAS7 — Thu, 07 Sep 2023 19:08:45 GMT

I reset the options missing=. and used sum() instead of +
I am getting correct results now.

Thanks for the help!

Re: Incorrect Row percent in Proc Report

Kurt_Bremser — Thu, 07 Sep 2023 19:16:58 GMT

options missing=0;

does not change any values, it only changes how they are displayed. Therefore the simple addition will still result in missing values also, and that's why you need to use the SUM function.

topic Incorrect Row percent in Proc Report in SAS Programming

Incorrect Row percent in Proc Report

Re: Incorrect Row percent in Proc Report

Re: Incorrect Row percent in Proc Report

Re: Incorrect Row percent in Proc Report