topic Re: proportions and proc tabulate in ODS and Base Reporting

proportions and proc tabulate

deleted_user — Wed, 28 Feb 2007 20:01:31 GMT

I would like to have proportions rather than percents output when I use Proc Tabulate.

For example, I have a program that reads as follows:

PROC TABULATE data = data set MISSING;
CLASS hotelname billprob;
TABLES NAME=' ',(billprob)*(n pctn)/ misstext='0';
RUN;

I am getting just what I want (the percent of people responding yes versus no to having a billing problem for each of a series of hotels). BUT ideally I would like a proportion.

I have searched and searched and can't seem to find a format or command to get proportions in proc tabulate.

Any ideas?

Thanks!!

Re: proportions and proc tabulate

deleted_user — Wed, 28 Feb 2007 20:03:34 GMT

For some reason an emoticon appeared where I had a > ... my program does NOT include a winking smiley face!!

Re: proportions and proc tabulate

Olivier — Fri, 02 Mar 2007 18:07:09 GMT

I can't think of any way to do that with a simple Tabulate procedure.
But I believe you can achieve this computing counts and proportions beforehand, storing them in a dataset, and creating a text variable with the right proportion in it. Then display your dataset with either REPORT or PRINT procedures, to get the right outfit.

Olivier