Help using Base SAS procedures

proc sql counts

Reply
N/A
Posts: 0

proc sql counts

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
Super Contributor
Super Contributor
Posts: 3,174

Re: proc sql counts

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
Contributor
Posts: 66

Re: proc sql counts

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

Re: proc sql counts

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;
Ask a Question
Discussion stats
  • 3 replies
  • 144 views
  • 0 likes
  • 3 in conversation