|
>SAS-L,
>
>This works:
>
>proc print data=test(where=(sum(x1,
>x2, x3)>80));
>run;
>
>and this works also:
> x4=sum(of x1-x3);
>
>This does not:
>proc print data=test(where=(sum(of
>x1-x3)>80));
>run;
>
>ERROR: Syntax error while parsing
>WHERE clause.
>
>What am I missing? Why does the
>where clause support the SUM
>function in one form but not another?
>
>Thans for any insight.
>
>Rodney
>
>Rodney J. Presley, Ph.D.
>PRO-West
>10700 Meridian Av. N., suite 100
>
Maybe someone else can provide the insight (which I can't), but if your
variables, x1, x2, x3 are consecutive variables you can use the following form:
where=(sum(x1--x3)>80)
Hope this helps,
Dan Nordlund
|
