sql - sum equal zero for variables for sas -

sql - sum equal zero for variables for sas -

i looked @ net not find relevant.

i have table thousands of variable.

i'm trying sum of 1 single variable , find out , variable in sum , equal zero.

example

col1 col2 col3 0 0 0 1 0 2 1 0 3

results

col2 0

however, proc means not want take clause.

proc sql; create table toto select nomvar,monotonic() num_lig dicofr nomvar <> 'date'; proc sql; select nomvar :varnom separated ' ' toto num_lig between 0 , 1000; %put varnom: &varnom; proc means data=afr sum (where=(sum(&varnom)=0) ; var &varnom; output out=want; run;

what doing wrong?

thank can lead me solution.

this it. believe requires sas 9.3+ stackedodsoutput option.

*generating data; info have; array x[100]; phone call streaminit(7); = 1 20; _t = 1 dim(x); if rand('uniform') < 0.9 x[_t]=0; else x[_t]=1; end; output; end; run; *ods output grabs want proc means; ods output summary=want(where=(sum=0)); proc means data=have sum stackodsoutput; var x:; run; ods output close;

sql sas