Hello,

I have a series of yes/no questions for which I would like to show the percent with a Yes and the total number of answers per period.

Question 1 Qtr1 Qtr2 Yes 33% 50% Total 100 80

Using the TABULATE procedure, I also get a row for "No" and the total is a percent:

Proc Tabulate Data = One ; Class audit_date documents_present ; Tables (documents_present all = "Total" ) , ( audit_date = "" all = "Entire period" ) * ( n = "N" * F = 8. pctn< documents_present all> = "%" * F = 8.1 ) ; Run ;

I get rusty with the TABULATE procedure and will probably go to a different solutions because I would rather have the data in one cell: 33% (33/100).

Can I limit the data shown in the TABULATE procedure? Can I mix statistics by row?

Thank you,

Kevin

Kevin Viel, PhD Senior Research Statistician Patient Safety & Quality International College of Robotic Surgery Saint Joseph's Translational Research Institute

Saint Joseph's Hospital 5671 Peachtree Dunwoody Road, NE, Suite 330 Atlanta, GA 30342

(678) 843-6076: Direct Phone (678) 843-6153: Facsimile (404) 558-1364: Mobile kviel@sjha.org Confidentiality Notice: This e-mail, including any attachments is the property of Catholic Health East and is intended for the sole use of the intended recipient(s). It may contain information that is privileged and confidential. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please delete this message, and reply to the sender regarding the error in a separate email.