Date:         Thu, 25 Aug 2011 18:12:31 -0500
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      AE table help
Content-Type: text/plain; charset=ISO-8859-1

Hello all,

I am doing a simple AE table where I want


                                                       Placebo (n=xx)
                     LY 3 mg (n=xx)
preferred term                                # events    incidence
           # events    incidence
Infections and Infestations
      Appendicitis
      Bronchitis

I am planning to use the following proc freq code , I know I am getting
#events count right in pt_term_count table , but how to get the incidence
values using the proc freq. I think I can use proc sql distinct (usubjid)
would give me what I want right but curious if there way to get in Proc freq
step ??

Proc freq data = event_count ;
by trtsort;
tables Socterm * pterm /out = pt_term_count ;
tables pterm * Usubjid  /list out = pt_term_subjid ;
run;

Thanks
Phani