Date:         Tue, 3 Apr 2007 19:22:19 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: proc tabulate : selective results for one level only
Comments: To: micotine@GMAIL.COM
In-Reply-To:  <200704031916.l33FfsiC026667@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

Use a Where clause to subset your data.



Toby Dunn

To sensible men, every day is a day of reckoning. ~John W. Gardner

The important thing is this: To be able at any moment to sacrifice that
which we are for what we could become. ~Charles DuBois

Don't get your knickers in a knot. Nothing is solved and it just makes you
walk funny. ~Kathryn Carpenter






From: Micotine Muso <micotine@GMAIL.COM>
Reply-To: Micotine Muso <micotine@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: proc tabulate : selective results for one level only
Date: Tue, 3 Apr 2007 15:16:32 -0400

Hi,

I am using proc tabulate to make a descriptive table for the data. The
variables of interest are dichotomous and prob tabulate gives me results for
both levels. However, I am only interested in one of the levels for each
variables. I have included my code below:
/* alcotab1 smoktab diabetes highedu aged are covariates */
/* wstcs is the exposure of interest with 5 levels. */

proc tabulate data=trott1 ;
    class wstcs alcotab1 smoktab diabetes highedu aged ;
    table (wstcs ='Waist Circumference' all='All')*
            (rowpctn='Percent (row total)' /*n='Number'*f=9.
             reppctn='Percent (total)'*/),
       highedu='high education' aged='>40 yrs' alcotab1='>3 drink/day'
smoktab='smok' diabetes='diab' / rts=40;
by sex;


Thanks
mico

_________________________________________________________________
Download Messenger. Join the i’m Initiative. Help make a difference today.
http://im.live.com/messenger/im/home/?source=TAGHM_APR07