I looked at the internet but I could not find anything relevant. I have a table with thousands of variable. I'm trying to do a sum of a variable and find out , which variable in sum , is equal to zero. example
col1 col2 col3
0 0 0
1 0 2
1 0 3
results
col2
0
However, my proc means does not want to take my where clause.
proc sql; create table toto as select nomvar,monotonic() as num_lig from dicofr where nomvar <> 'date';
proc sql; select nomvar into :varnom separated by ' ' from toto where num_lig between 0 and 1000;
%put varnom: &varnom;
proc means data=afr sum (where=(sum(&varnom)=0) ; var &varnom; output out=want; run;
What am I doing wrong? One thing though, I'm looking for something simple and not overly complex. TIA for your suggestions.
... View more