- proc sql;
- select distinct product,(select sum(sales)
- from two where two.id=one.id) as total from one
- left join two
- on one.id=two.id;
- quit;
楼主: 青衣默东行
|
3194
10
sas sql in-line view 语句 |
| ||
京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明 免责及隐私声明