用SQL语句，交叉查询

2# zhaozyuan

能不能再多告诉我点。。sql 从来没用过，我是sas菜鸟

你用什么软件做？

4# naver

SAS的9.1版做的啊

data test;
input code $ date $ time $ type $ number;
datalines;
RX000152   03/11/2009  11:27:53  AP3965    5
RX000170   04/11/2009  05:55:50  AT3600    6
RX000189   06/11/2009   09:07:45  AT3600   3
RX000179   03/11/2009  12:32:28  AP3965    5
RX000141   01/11/2009  08:49:26  AT3600    2
RX000149   02/11/2009  11:54:23  AP3965    1
RX000215   04/11/2009  14:09:49  AP3965    1
RX000230   09/11/2009   19:28:32  AP3965   2
;
run;

proc sql;
create table test1 as
select code, date, type, sum(number) as sum
from test
group by code, date, type
order by code, date, type;
quit;

proc transpose data=test1 out=test2;
by code date;
var sum;
id type;
run;