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='#') ;
I want to add an extra column average next to sum.
Thanks in advance for help
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?
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;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.