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; ... View more

data have; input contract classe_201801 $ classe_201802 $ classe_201803 $ classe_201804 $ classe_201805 $ classe_201806 $ classe_201807 $ classe_201808 $ classe_201809 $ classe_201810 $ classe_201811 $ classe_201812 $ ; datalines; 111111 A B B B A A A B B B B C ; run; %macro mc_histo_rece ; %let N=1 ; data want; set have ; array array_classe(12) classe_:; %do i=1 %to 11 ; %let suivant=%eval(&i+1) ; if array_classe(&i) ne "B" and array_classe(&suivant) eq "B" then do ; begin_&N = substr(vname(array_classe(&suivant)),8,6) ; %let N = %eval(&N + 1) ; end ; %end ; run; %mend ; %mc_histo_rece ; Hello, I need to obtain 2 new column, one column named begin_1 that holds 2018 and one column named begin_2 that holds 201808 because 201802 is the first begining of periode B and 201808 is the begining of the second periode B thanks a lot in advance for your help Nasser ... View more

data have; input contract periode status $ ; datalines; 111111 201801 B1 111111 201802 B1 111111 201803 B2 111111 201804 B3 111111 201805 B1 111111 201806 B1 222222 201801 B1 222222 201802 B2 222222 201803 B3 222222 201804 B3 222222 201805 B3 222222 201806 B3 ; run; data want; input contract periode status $ ; datalines; 111111 201805 B1 222222 201803 B3 ; run; hello,   I would like to get the beginning periode of the last value for each contract thanks in advance for your help Nasser ... View more

hello,   I use proc print to display the data of a dataset into an excel file. my problem is that the first column is too width in excel thanks in advance for your help regards Nasser ... View more

Hello,   I've got a table (generated by proc compare) that holds around 170 columns and 150 000 rows. for all lines and all columns, I would like to perform the same operation. for example replace '.' by ' ' ; thanks a lot in advance for your help regards Nasser ... View more