怎样用sql把一个数据集纵向截成三段然后横向连接，自己编了一个，有error

120788893 发表于 2015-9-22 15:42
do循环按ABC截取3个数据集，然后merge不好么

多谢提醒，回头试一下

proc sql ;
create table work.means_2 as
select A.*, B.GroupB, C.GroupC
from work.means_1 (where=(group="A") rename=(_Stat_=Item Age=GroupA)) as A
full join work.means_1 (where=(group="B") rename=(_Stat_=Item Age=GroupB)) as B
on A.Item=B.Item
full join work.means_1 (where=(group="C") rename=(_Stat_=Item Age=GroupC)) as C
on A.Item=C.Item ;
quit ;

teqel 发表于 2015-9-22 22:12
proc sql ;
create table work.means_2 as
select A.*, B.GroupB, C.GroupC

多谢多谢
select A.*, B.GroupB, C.GroupC
这行是什么意思
为什么是 A.*, B.GroupB, C.GroupC