求助高手:如何根据配制表,来抽取数据,组成宽表?

shiyiming

大哥说得好, <!-- s:( --><img src="{SMILIES_PATH}/icon_sad.gif" alt=":(" title="Sad" /><!-- s:( --> 多谢教诲.

shiyiming

[code:2zts6zf6]
proc sql;
     create table taball as
         select name1, sex1, age1, sex2, age2, weight3, age3, height3
         from class, class1, class2, class3
         where class1&#46;name1=class2&#46;name2=class3&#46;name3
         order by class1&#46;name1;
quit;
[/code:2zts6zf6]