turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS Procedures
- /
- Tabulate, mean, and denominator

Topic Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-18-2010 07:00 PM

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).

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

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

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).

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to steve_citi

07-18-2010 08:22 PM

Hi:

Is this the same data scenario as in this previous posting?

http://support.sas.com/forums/message.jspa?messageID=38685#38685

cynthia

Is this the same data scenario as in this previous posting?

http://support.sas.com/forums/message.jspa?messageID=38685#38685

cynthia