sas - 您如何在 proc sql 中重新使用 SAS 中的字段？

Question

如果有数据步骤:

data myRegions;
set myRegions;
ext_price = price * qty;
mix = weighted_calc * ext_price;
run;

我想在 SQL 上执行此操作，因为我想使用一些分组和子查询
但我必须做 price * qty每次我想使用那个值时操作？!

Answer 1

您可以使用 calculated ，来自文档:

CALCULATED enables you to use the results of an expression in the same SELECT clause or in the WHERE clause. It is valid only when used to refer to columns that are calculated in the immediate query expression.

下面是一个例子:

proc sql;    
create table myRegions as
Select a.*,  
        (price * qty) as ext_price ,
        (weighted_calc * calculated ext_price ) as mix
from     myRegions;
quit;