topic Re: proc report observation total count per row in SAS Procedures

proc report observation total count per row

sebster24 — Thu, 08 Aug 2019 13:27:22 GMT

Dear All,

I am trying to create a table which computes the total observation count per row (across a group) using proc report.

Could someone help me with this endeavour?


proc report data=sashelp.shoes nowd;
column region Product;
define region /group order=internal;
define Product / across 'Product across';
rbreak after/ summarize style=Header;
compute after;
region="Total";
endcomp;
run;

Thanks

Re: proc report observation total count per row

ballardw — Thu, 08 Aug 2019 14:33:38 GMT

Is this what you are looking for?

proc report data=sashelp.shoes nowd;
column region Product n;
define region /group order=internal;
define Product / across 'Product across';
rbreak after/ summarize style=Header;
compute after;
region="Total";
endcomp;
run;

Re: proc report observation total count per row

sebster24 — Thu, 08 Aug 2019 14:43:37 GMT

thank you