|
Irin,
See if this gets what you are after...
data test;
input Adm_key adm_mem_num Process_Yyyymm;
process_yr = substr(left(process_yyyymm),1,4);
cards;
8 12 200502
8 12 200504
9 11 200501
9 11 200408
7 10 200504
7 10 200402
7 10 200309
;
run;
proc sql;
create table new as
select adm_key, count(distinct process_yr) as year_cnt, count(*) as
adm_cnt
from test
group by adm_key
;
quit;
proc freq data = new;
tables year_cnt / nocum nopercent;
weight adm_cnt;
run;
Jack Clark
Research Analyst
Center for Health Program Development and Management
University of Maryland, Baltimore County
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Irin
later
Sent: Friday, February 23, 2007 2:55 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: How many in a single year ; in more than a single year and etc
I have Adm_key ; Adm_mem_num fields and process_year.
Adm_key adm_mem_num Process_Yyyymm
8 12 200502
8 12 200504
9 11 200501
9 11 200408
7 10 200504
7 10 200402
7 10 & nbsp; 200309
# Variable Type Len Pos Format Informat Label
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒ
1 Adm_Key Num 8 0 Adm Key
2 Adm_Mem_Num Num 8 8 Adm Mem Num
3 Process_Yyyymm Num 8 32 Process Yyyymm
I need to know how many claims are in a single process year (regardless
monthes) and how many in more than single year. Something like the following
statistics based on the file above:
Just 2 admissions have claims in a single year (2005)
2 of them have claims in 2 different years (2005 & 2004)
3 of them have claims in more than 2 different years (2005 & 2004& 2003)
How can I produce this statistics??
Thank you in advance,
Irin
---------------------------------
8:00? 8:25? 8:40? Find a flick in no time
with theYahoo! Search movie showtime shortcut.
| 
