**Date:** Mon, 4 Aug 2008 19:32:37 -0400
**Reply-To:** SAS_learner <proccontents@GMAIL.COM>
**Sender:** "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
**From:** SAS_learner <proccontents@GMAIL.COM>
**Subject:** Re: Count function in PROC SQL
**In-Reply-To:** <622163.7463.qm@web46004.mail.sp1.yahoo.com>
**Content-Type:** text/plain; charset=ISO-8859-1
hello lee ,
Is this what u are looking for

data test;
input name $2. Type $2. zipcode zip3 ;
datalines ;
A N 12345 123
B N 12345 123
C P 22222 222
D P 33333 333
E P 44444 444
F P 55555 555
G P 12355 123
K P 22225 222
;
Run;

proc sql noprint ;
create table test_1 as
select *, count(type) as type_count
From test
group by zipcode;
Quit ;

Let me know if the result does not match or what exactly u want

thanks

On Mon, Aug 4, 2008 at 7:03 PM, Kitty Lee <kit_lee2008@yahoo.com> wrote:

> Hi All,
> I have a question on counting by type and zip3 (the first 3 digit of a
> zipcode) level. I think PROC SQL is probably the best way to count but I am
> not too familiar with SQL.
> The following is my rawdata. Basically, I would like to count how many
> names at zip3 level by type.
> e..g.
> Zip3 = 123 would have 2 Ns and 1P
> Zip3 = 222 would have 0Ns and 2Ps etc...
> Any ideas would help. Thank you very much!!
> zipcode name Type zip3
> 12345 A N 123
> 12345 B N 123
> 22222 C P 222
> 33333 D P 333
> 44444 E P 444
> 55555 F P 555
> 12355 G P 123
> 22225 K P 222
>
>
>