topic Re: Calculate Average using Proc Tabulate in SAS Procedures

Calculate Average using Proc Tabulate

Ady23 — Fri, 17 Aug 2018 12:37:12 GMT

I want to generate a report using PROC TABULATE,

It will contain sum and average of the variables specified in class.

I am able to calculalte sum, but couldnt generate mean/average

title "Credit Sentry Report";

proc tabulate data=CreditSentryFlag3 missing;

format applicationdate weekdate17.;

class flagname applicationdate /descending;

table flagname='' all='Total', (applicationdate='')*(N='') (all='SUM')*(N='#') ;

run;

I want to add an extra column average next to sum.

Thanks in advance for help

--ADITYA

Re: Calculate Average using Proc Tabulate

PaigeMiller — Fri, 17 Aug 2018 12:41:28 GMT

Since I don't know PROC TABULATE, I can't fix your code. However, the whole thing is very easy to do in PROC SUMMARY or PROC REPORT, and I could provide example code for either of those.

Re: Calculate Average using Proc Tabulate

Ady23 — Fri, 17 Aug 2018 12:44:26 GMT

If any of those PROC helps me get the sum and mean or average, i`ll wil happy to use it, can you please provide the steps.

Re: Calculate Average using Proc Tabulate

PaigeMiller — Fri, 17 Aug 2018 12:53:21 GMT

Okay, well I need a little clarification from you.

What is the name(s) of the continuous variable you want to sum and average? It seems like you have only specified class variables in the code you show above. And you want both flagname and applicationdate to be class?

Re: Calculate Average using Proc Tabulate

Cynthia_sas — Fri, 17 Aug 2018 13:43:14 GMT

HI:
You need to have a VAR statement with an analysis variable in order to get the MEAN statistic. It doesn't make sense to get the mean of either applicationdate or flagname. There must be a numeric variable someplace in your data that is the one you want the MEAN statistic for.

proc tabulate data=sashelp.shoes;
where product in ('Boot' 'Sandal' "Men's Dress" "Women's Dress");
class product region ;
var sales;
table region='Region' all='Total', 
      (product='')*(N='') (all='SUM')*(N='#') sales*mean;

run;

Cynthia