topic Re: PROC REPORT Summarize columns in SAS Programming

PROC REPORT Summarize columns

West26 — Tue, 01 Feb 2022 02:51:51 GMT

Hello,

Need help with summarizing columns with PROC REPORT

PROC REPORT DATA=WANT nowd;

column Serial Prog Type Height Weight Rate;

define Serial / order;

define Prog / group;

define Type / noprint;

define Height / display;

define Weight / display;

define Rate / noprint;

compute Rate;

if Rate= 'End' then

call define (_row_,"style","style={background=yellow}");

endcomp;

run;

I need to summarize Height and Weight variables and display the number under Height and Weight Columns.

Thanks.

andreas_lds — Tue, 01 Feb 2022 06:31:07 GMT

In the define statements of the variable: change "display" to "sum".

Ksharp — Tue, 01 Feb 2022 07:46:01 GMT

Post some data and output you want to see, so we can better understand your question.

West26 — Wed, 02 Feb 2022 22:24:45 GMT

Sure, will get back on that. Thanks for your time

West26 — Wed, 02 Feb 2022 22:25:38 GMT

It didn't work that way, I've tired. I'll get back with some added data later on,