Date:         Tue, 31 Mar 2009 10:12:59 -0400
Reply-To:     Mike Rhoads <RHOADSM1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mike Rhoads <RHOADSM1@WESTAT.COM>
Subject:      Re: Producing a Questionaire Table with Sub Questions
In-Reply-To:  <ce1fb7450903310538m589d8b0ndf5f0c2d32448f38@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

David,

It would also help to know:

1. What version of SAS you are running (probably 9.1.3 or 9.2)?
2. What type of report file you need to produce (HTML, PDF, Word document, old-fashioned listing, etc.)?

I suspect that multi-label formats may be the way to go, with PROC TABULATE.  This would require you to get all of your "Bad eye" data into a single variable (recode if necessary).  Same for Foot Injury etc.

Mike Rhoads
RhoadsM1@Westat.com


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of ./ ADD NAME=Data _null_;
Sent: Tuesday, March 31, 2009 8:38 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Producing a Questionaire Table with Sub Questions


I would like to see some of the data that makes up this table.  To me how one might proceed would depend partly on the starting point, do you have lots of variables or lots of rows.  Post some of your data in an e-mail friendly format.

On 3/30/09, David Friedman <harrypotterdhf@earthlink.net> wrote:
> Hi, i am trying to make a table like the example below. When a patient
> answers a question "No" there is no further question, however if he
> answers the question "Yes" then there are other questions. The
> denominator is Total treated, however, when a question is answered
> "yes" the response below "Yes" is a percentage of the "Yes" question.
> Do you know what is the best way to do a table like this? Thanks!!!! I
> am struggling. Since this is an example table, the Treatment2 column
> was purposely not filled in, and there can be more than 2 questions.
> In this case there is an eye and foot question.
>
>                  Treatment1  Treatment2
> Total Treated      60 (100.0)  60 (100.0)
>
> Eyes are bad?
>   No              30 (50.0)
>   Yes             30 (50.0)
>    Cornea stain   15 (25.0)
>    Cataracts      15 (25.0)
>
> Foot Injury
>    No             20 (33.3)
>    Yes            40 (66.7)
>      Ingrown nail 10 (16.7)
>      Bunion       30 (50.0)
>