标题: proc sql选择multiple columns [打印本页] 作者: shiyiming 时间: 2011-1-2 09:49 标题: proc sql选择multiple columns sas adv prep guide 有这样一个问题：
Complete the following proc sql query to select the columns address and sqfeet from the table list.size and to select price from the table list.price. (only the address column appears in both tables.)
proc sql;
_______________
from list.size,list.price;
a select address,sqfeet,price
b select size.address,sqfeet,price
c select price.address,sqfeet,price
d either b or c
书上说是b 但我觉得应该是d，大家觉得应该是哪一个？作者: shiyiming 时间: 2011-1-2 11:18 标题: Re: proc sql选择multiple columns 问的是“select the columns address and sqfeet from the table list.size”，明确要求了要从list.size中选择address吧作者: shiyiming 时间: 2011-1-2 15:31 标题: Re: proc sql选择multiple columns 感谢