proc sql noprint;
create table bds as
select id,sum(seq) as seq,sum(x) as x
from ads
group by id;
insert into ads (id,seq,x)
select *
from bds;
create table cds as
select *
from ads
order by id;
quit;
[/code:1kqjdxuh]作者: shiyiming 时间: 2012-6-20 09:06 标题: Re: 请教各位高手一个关于SQL的一个问题 [code:1u0b1crz]--创建源表
drop table aa purge;
create table aa (id number, seq number,x number);
insert into aa values (1,1,5);
insert into aa values (1,2,6);
insert into aa values (2,1,7);
insert into aa values (2,2,4);
insert into aa values (3,1,6);
insert into aa values (3,2,4);
commit;
--创建变换表
drop table result purge;
create table result as
select * from(
select id,seq,x from aa
union all
select id,max(seq)+1,sum(x) from aa group by id
)
order by id,seq;
[/code:1u0b1crz]作者: shiyiming 时间: 2012-7-12 22:45 标题: Re: 请教各位高手一个关于SQL的一个问题 mark!作者: shiyiming 时间: 2012-7-18 02:39 标题: Re: 请教各位高手一个关于SQL的一个问题 proc sql;
create table b as
select id, sum(seq) as seq,sum(x) as x from a group by id;
select * from a union corr select * from b;
quit;