81   proc sql ;
81 !                                                       *xxxxxxxxxxxxxxxxxxxxxxxx;
82        create table work.means_2  as
83           select  means_1.*
84           from work.means_1 (where=(group="A")) as A
85           full join work.means_1 (where=(group="B")) as B
86           on A._STAT_=B._STAT_  ;
WARNING: Correlation name means_1 identifies more than one table.
WARNING: Variable Group already exists on file WORK.MEANS_2.
WARNING: Variable _STAT_ already exists on file WORK.MEANS_2.
WARNING: Variable Age already exists on file WORK.MEANS_2.
NOTE: Table WORK.MEANS_2 created, with 5 rows and 3 columns.

有错误啊  数据集只出来了B列

81   proc sql ;
81 !                                                       *xxxxxxxxxxxxxxxxxxxxxxxx;
82        create table work.means_2  as
83           select  means_1.*
84           from work.means_1 (where=(group="A")) as A
85           full join work.means_1 (where=(group="B")) as B
86           on A._STAT_=B._STAT_  ;
WARNING: Correlation name means_1 identifies more than one table.
WARNING: Variable Group already exists on file WORK.MEANS_2.
WARNING: Variable _STAT_ already exists on file WORK.MEANS_2.
WARNING: Variable Age already exists on file WORK.MEANS_2.
NOTE: Table WORK.MEANS_2 created, with 5 rows and 3 columns.

数据集只出来了GroupB的，

81   proc sql ;
81 !                                                       *xxxxxxxxxxxxxxxxxxxxxxxx;
82        create table work.means_2  as
83           select  means_1.*
84           from work.means_1 (where=(group="A")) as A
85           full join work.means_1 (where=(group="B")) as B
86           on A._STAT_=B._STAT_  ;
WARNING: Correlation name means_1 identifies more than one table.
WARNING: Variable Group already exists on file WORK.MEANS_2.
WARNING: Variable _STAT_ already exists on file WORK.MEANS_2.
WARNING: Variable Age already exists on file WORK.MEANS_2.
NOTE: Table WORK.MEANS_2 created, with 5 rows and 3 columns.

数据集只出来了GroupB的，

想尝试一下别的方法

多谢提醒，回头试一下

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 ;

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