Hello,
I get a dataset that holds this data (among others rows)
trim_enc | tx_enc | s |
39 | 0,011938547 | 8 |
39 | 0,008377295 | 7 |
39 | 0,010034088 | 6 |
39 | 0,005785525 | 5 |
39 | 0,007288286 | 1 |
so, the mean of tx_enc for the trim_enc 39 should be 0.0086 but in the output window, the mean displayed is 0.005428
because sas considers tx_enc 0 for s=2 , 3, 4 (missing row are included in the calculation)
How can I exclude missing rows ?
thanks in advance for your help
regards,
Nasser
proc tabulate data=encaiss_8dertrim_detail order=DATA ;
title j=l TAUX MOYEN DES 8 DERNIERS TRIMSTRES CTX (detail) ;
where s > 0 ;
class s trim_enc ;
var tx_enc ;
table trim_enc="" , s=""*tx_enc=""*mean=""*f=10.5 ;
quit;