sas sql in-line view 语句

试一次这一段，在select中生成total，效果一样

1. proc sql;
   
2.         select distinct product,(select sum(sales)
   
3.                                                                         from two where two.id=one.id) as total from one
   
4.         left join two
   
5.         on one.id=two.id;
   
6. quit;

复制代码