proc sql counts

[deleted_user]

I have this data:
year v1
2008 x
2008 x
2008 y
2009 x
2009 x
2009 x
2009 y
2009 y

How would I use proc sql to get this?
year v1 count
2008 x 2
2008 y 1
2009 x 3
2009 y 2

Is it possible to get this with proc sql:
v1 2008 2009
x 2 3
y 1 2

[sbb]

Have you looked at the PROC SQL documentation regarding question #1?

For question #2, you should use PROC TRANSPOSE.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic/post:

proc sql counts site:sas.com

[sas_]

proc sql;
select year,v1, count(v1) as cnt from data group by year,v1;
quit

[sas_]

For this output:
v1 2008 2009
x 2 3
y 1 2



proc sql;
create table l as
select year,v1, count(v1) as cnt from emp group by year,v1;
quit;

proc sort data=l;
by v1;
run;


proc transpose data=l out=l2(drop=_NAME_);
id year;
by v1;
run;