topic Re: proc sql counts in SAS Procedures

proc sql counts

deleted_user — Thu, 18 Mar 2010 21:31:49 GMT

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

Re: proc sql counts

sbb — Thu, 18 Mar 2010 22:07:34 GMT

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

Re: proc sql counts

sas_ — Mon, 22 Mar 2010 06:53:59 GMT

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

Re: proc sql counts

sas_ — Mon, 22 Mar 2010 06:57:53 GMT

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;