Date:         Fri, 2 Mar 2012 11:39:33 -0800
Reply-To:     Irin later <irinfigvam@yahoo.com>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Irin later <irinfigvam@YAHOO.COM>
Subject:      PROC FREQ for 3 variables
Content-Type: text/plain; charset=iso-8859-1

I have a table "ALL" with the following columns: RateCat,Age3Cat and Specialties
 
RateCat   Age3Cat  Specialties
GE50      child    internalMedicine Pediatric   
LE50      elderly  FamilyPractice Pulmanilogy
LE50      child    Pediatric
LE50      child    Allergy
GE50      child    FamilyPractice
GE50      other    OB
GE50      other    Immunology Internal 
LES0      ELSERLY  InternalMmedicineRadiology

I now how to do
Proc Freq data=All;
table RateCat*Specialties;
run;
as well as 

Proc Freq data=All;
table Age3Cat*Specialties;
run;
However I am looking for a way to use Proc Freq in order to evaluate 
which and how many specialties belong   to the rates categies for for  elderly and children Age Categories (Age3Cat) . Especially for highest rates (RateCat >=50%)
 
In other words, I need to use three variables to reveal a whole picture.
 Is there any way to do it?
 
 
Could please you give me a hand on it?
 
Thank you in advance!
Irin