Date:         Fri, 2 Mar 2012 19:59:44 +0000
Reply-To:     "Zdeb, Michael S" <mzdeb@ALBANY.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Zdeb, Michael S" <mzdeb@ALBANY.EDU>
Subject:      Re: PROC FREQ for 3 variables
Comments: To: Irin later <irinfigvam@yahoo.com>
In-Reply-To:  <1330717173.45233.YahooMailNeo@web39403.mail.mud.yahoo.com>
Content-Type: text/plain; charset="us-ascii"

hi ... if what you want to see are frequencies/percentages within rate categories, you could sort your data and then use by-group processing  ...

data x;
input RateCat : $4.  Age3Cat : $7.  Specialties & : $25.;
datalines;
GE50      child    internalMedicine Pediatric
LE50      elderly  FamilyPractice Pulmanilogy
LE50      child    Pediatric
LE50      child    Allergy
GE50      child    FamilyPractice
GE50      other    OB
GE50      other    Immunology Internal
LE50      elderly  InternalMmedicineRadiology
;

proc sort data=x;
by ratecat;
run;

proc freq data=x;
tables age3cat*specialties / list nocum;
by ratecat;
run;

Mike Zdeb
U@Albany School of Public Health
One University Place (Room 119)
Rensselaer, New York 12144-3456
P/518-402-6479 F/630-604-1475

________________________________________
From: SAS(r) Discussion [SAS-L@LISTSERV.UGA.EDU] on behalf of Irin later [irinfigvam@yahoo.com]
Sent: Friday, March 02, 2012 2:39 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: PROC FREQ for 3 variables

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