BookmarkSubscribeRSS Feed
steve_citi
Calcite | Level 5
If the mean of a variable is referenced in a tabulate, and then once again the variable is referenced as a denominator, will the mean be used?

Suppose I have a dataset which contains 12 records. One for every month. On that record is a variable called call_dropped, and another variable called total calls.

For a monthly report, the percent of calls dropped would be expressed as

proc tabulate data=mydata
calls_dropped = ''*sum='Calls Dropped'*f=comma6.
total_calls = ''*sum='Total Calls'*f=comma9.
calls_dropped =pctsum='Percent Dropped'*f=pctfmt8.2,
month=' '
/box='Call Data';

BUT, If I wanted a yearly average, I would do the following:

calls_dropped = ''*mean='Avg. Calls Dropped per Month'*f=comma6.
total_calls = ''*mean='Avg. Total Calls per Month'*f=comma9.
calls_dropped =pctsum='Avg. Percent Dropped per Month'*f=pctfmt8.2,
month=' '
/box='Call Data';

Since there is no pctmean, what would the denominator for this expression be? The mean of all 12 months (as I would like), or the sum of all 12 months (not good).
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
Is this the same data scenario as in this previous posting?
http://support.sas.com/forums/message.jspa?messageID=38685#38685

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 767 views
  • 0 likes
  • 2 in conversation