Hi thanks for your support - please find the copy of the log from sas studio, regards François. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 /* procedure Analyse Tracs DG NEW SCORE - FW 02-03-2017 */ 57 58 data sasdata.tracs; 59 set 60 analyse.BY2636_FW 61 ; 62 63 length statut $12. ; 64 if 65 (oq=oq06M & oq=1) then statut = 'NEW_UNIQUES'; 66 else if 67 (oq=oq06M & oq>1) then statut = 'NEW_MULTIS'; 68 else if 69 (oq>oq06M and oq06M=1) then statut = 'NEW_REACT'; 70 71 else statut = 'MULTIS'; 72 73 Dec_J2_num = input (Dec_J2,4.); 74 length Dec_J2_num 4 ; 75 drop Dec_J2; 76 rename Dec_J2_num=Dec_J2; 77 78 if (1 <= dolp <= 26) and statut in ('NEW_MULTIS','NEW_REACT','MULTIS') then 79 80 Score_New = 81 -1.89304 82 +dolp* -0.013604 83 +iresp06m* 1.58685 84 +npromodolp* -0.035831 85 +nosweep* -0.10951 86 +oq01m* 0.004549523 87 +oqdg03m* 0.071948 88 +smt2* 0.003231638 89 +dolt* -0.003026975 90 +doldg* -0.007273165 91 +eqdg* 0.000036164 92 +dolmt* -0.001203701 93 ; 94 Score_New = exp(Score_New) / (1+exp(Score_New)) 95 ; 96 97 /* reconstitution Nouveaux Déciles */ 98 99 IF (Score_New>=0.214860685270079)THENDecile ='01'; 100 ELSE IF(0.149546433457333<=0.214860685270079)THENDecile ='02'; 101 ELSE IF(0.109435786177266<=0.149546433457333)THENDecile ='03'; 102 ELSE IF(0.0845282863987305<=0.109435786177266)THENDecile ='04'; 103 ELSE IF(0.0652380199212249<=0.0845282863987305)THENDecile ='05'; 104 ELSE IF(0.0499707174667324<=0.0652380199212249)THENDecile ='06'; 105 ELSE IF(0.0387321478803584<=0.0499707174667324)THENDecile ='07'; 106 ELSE IF(0.0295266058729593<=0.0387321478803584)THENDecile ='08'; 107 ELSE IF(0.0225046222142513<=0.0295266058729593)THENDecile ='09'; 108 ELSE Decile ='10'; 109 110 if (1 <= dolp <= 26) and statut = 'NEW_UNIQUES' then 111 112 Score_Unik = 113 -1.8964 114 +dolp*-0.0155 115 +npromodolp*-0.0818 116 +iresp03M* 0.63 117 +sq* 0.0445 118 +dofs* -0.00254 119 ; 120 Score_Unik = exp(Score_Unik) / (1+exp(Score_Unik)) 121 ; 122 if (1 <= dolp <= 26) and statut = 'NEW_UNIQUES' then Decile = '99'; 123 124 if oqV<1 then oqV2=0; else oqV2=oqV; 125 mqV2=1; 126 RDT=oqV2 / mqV2; 127 128 run; NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 5071 dans 94:13 5071 dans 94:32 5071 dans 94:33 44559 dans 120:14 44559 dans 120:34 44559 dans 120:35 NOTE: There were 49630 observations read from the data set ANALYSE.BY2636_FW. NOTE: The data set SASDATA.TRACS has 49630 observations and 391 variables. NOTE: DATA statement used (Total process time): real time 0.13 seconds cpu time 0.12 seconds 129 130 proc freq data= sasdata.TRACS ; 131 132 tables oqV oqV2 mqV mqV2 dolp mediacd datatrac 133 Dec_J2 Decile Dec_DG_MULTI_FW1 QUA_DG_UNI_FW1 statut ; 134 tables Statut * Dec_DG_MULTI_FW1 ; 135 Tables Statut * Decile ; 136 Tables Statut * Dec_J2 ; 137 Tables Dec_DG_MULTI_FW1 * Dec_J2 ; 138 Tables Decile * Dec_J2 ; 139 Tables applidecile * eliminedecile ; 140 Tables mediacd * applidecile ; 141 Tables mediacd * deciletrac ; 142 Tables mediacd * oqv2 ; 143 Tables mediacd * eliminedecile ; 144 145 run; NOTE: There were 49630 observations read from the data set SASDATA.TRACS. NOTE: PROCEDURE FREQ used (Total process time): real time 1.09 seconds cpu time 1.11 seconds 146 147 proc means data= sasdata.TRACS ; output out=out.out1; 148 var RDT ; class Decile ; 149 run; NOTE: There were 49630 observations read from the data set SASDATA.TRACS. NOTE: The data set OUT.OUT1 has 60 observations and 5 variables. NOTE: PROCEDURE MEANS used (Total process time): real time 0.05 seconds cpu time 0.06 seconds 150 151 proc means data= sasdata.TRACS ; output out=out.out2; 152 var RDT ; class mediacd; 153 run; NOTE: There were 49630 observations read from the data set SASDATA.TRACS. NOTE: The data set OUT.OUT2 has 120 observations and 5 variables. NOTE: PROCEDURE MEANS used (Total process time): real time 0.06 seconds cpu time 0.06 seconds 154 155 proc freq data= sasdata.TRACS ; 156 where mediacd IN ( 157 158 'BY26362003', 159 'BY26362102', 160 'BY26362303', 161 'BY26362402', 162 'BY26362403', 163 'BY26362502' 164 165 ); 166 Tables eliminedecile * mediacd * deciletrac ; 167 run; NOTE: There were 23169 observations read from the data set SASDATA.TRACS. WHERE mediacd in ('BY26362003', 'BY26362102', 'BY26362303', 'BY26362402', 'BY26362403', 'BY26362502'); NOTE: PROCEDURE FREQ used (Total process time): real time 0.20 seconds cpu time 0.20 seconds 168 169 170 171 172 173 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 185
... View more