Date:         Thu, 31 Aug 2006 06:36:00 -0700
Reply-To:     Ai Hua Wang <aihuawang@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ai Hua Wang <aihuawang@YAHOO.COM>
Subject:      Proc Tabulate Output meets my goal?
Content-Type: text/plain; charset=iso-8859-1

Hello:

Thank you very much for answering my previous
question. I get beautiful tables from PROC TABULATE
after adding ODS. I have a point where I can not judge
myself. I am not one hundred percent sure if the
following codes produce the number of counts for the
first category of ICD9. I know I can check the cell
number by proc contents after extracting the data
corresponding to the stratification of that cell from
the master file. But the breakdown is very fine so
that I have so many cells. Therefore I am looking for
help making sure I am doing the right thing.

I want to know the number of counts for the first
category of ICD9 for each stratification by
fiscalyear, province, agegroup and sex. Let me
describe what my codes are doing. The first block
extracts the data belonging to the first category of
ICD9 code. The second block generates the counts. Can
anyone take a little time to help me check?  Thanks.

Aihua

*produce output for category 1;
data ICD9_CAT_1;
set temp;
where ICD9_Code=1;
run;

ods html file="...\ICD9_CAT_1.xls";
proc tabulate data=ICD9_CAT_1 f=best12.2;
class fiscal_Yr facility_province Age_Group sex;
var ICD9_code;
tables fiscal_Yr*facility_province, Age_Group*sex;
run;
ods html close;


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com